View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tommy Tommy is offline
external usenet poster
 
Posts: 70
Default macro to loop thru sheets and add info

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.