You can use record macro in Excel (Tools-> Macro-> Record New Macro)
Then record the task you’re doing and it will automatically write a macro for you. Record the complete task that you want to do. (Single pass task before it goes to same task or loop)
Ex: Highlight row then copy and go to another cell and then paste.
After recording the macro click Stop Macro. Then go to Tools-> Macro-> Visual Basic Editor. Find folder Module on the left (Project Object) and double click Module 1 or any module created. On the right side window panel it show the recorded code. Copy and paste the code in this post so I can understand what do you want to do and I will modify the code to create the loop that you can execute to do the task automatically.
Member for
19 yearsRE: Excel VBA Help (I didn’t know where else to put it?)
Tim,
You can use record macro in Excel (Tools-> Macro-> Record New Macro)
Then record the task you’re doing and it will automatically write a macro for you. Record the complete task that you want to do. (Single pass task before it goes to same task or loop)
Ex: Highlight row then copy and go to another cell and then paste.
After recording the macro click Stop Macro. Then go to Tools-> Macro-> Visual Basic Editor. Find folder Module on the left (Project Object) and double click Module 1 or any module created. On the right side window panel it show the recorded code. Copy and paste the code in this post so I can understand what do you want to do and I will modify the code to create the loop that you can execute to do the task automatically.
Best Regards,
Rodel