#1
|
|||
|
|||
how modify a macro code
Hello .
Delighted to be among you. I am asking you please to help me to modify a macro code by keeping its function and add a line to open another sheet (sheet 2) in the same workbook. the code : Sub Veron() Application.ScreenUpdating = False y = WorksheetFunction.CountA(Worksheets(2).Range("A:A" )) + 2 For x = 1 To 800 Worksheets(2).Cells(y, x) = Worksheets(1).Cells(8, 9 + x) Next x ans = MsgBox("Nom Ajouté", vbOKOnly) End Sub the file http://www.filedropper.com/doc1 thank you in advance |
#2
|
||||
|
||||
Please do not cross post without adding links
read this to understand why and add links to ALL your cross posts http://www.mrexcel.com/forum/excel-q...acro-code.html http://www.excelforum.com/excel-prog...acro-code.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how can I modify this macro to work on another column besides "A" | zhead | Excel Programming | 5 | 10-06-2015 05:04 PM |
VBA Macro code help | get4hari | Excel Programming | 8 | 09-26-2015 10:33 PM |
Looking Again for Another Code/Macro | rsrasc | Word VBA | 5 | 11-16-2014 05:47 AM |
Recovering/Removing a Password to Modify PPAM Code | Steve_B | PowerPoint | 3 | 01-08-2014 01:06 PM |
Modify vba code to print based on name in the InputBox | OTPM | Project | 0 | 05-25-2011 02:03 AM |