create macro to loop thru worksheets and update them

T

Tommy

Want to create a macro/vba to make a stop in every worksheet of the open
workbook and insert company name in A1 (of course, insert a row in A1 first),
then go to the next sheet and do the same. Some of my files have 2
worksheets, some have 8, some have 25. Need to make sure macro works
regardless of the number of worksheets in a workbooks. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to loop thru sheets and add info 3
Create Workbooks and then create Worksheets within them 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Loop Thru Worksheets 2
Macro to format multiple worksheets 24
Rename worksheets macro needed 3
Macro to combine worksheets 10
Rename worksheets macro 2

Top