View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Hari Prasadh[_2_] Hari Prasadh[_2_] is offline
external usenet poster
 
Posts: 83
Default Looping through Worksheets

Hi Steve,

Sub Loop_sheets()
Dim sh as worksheet

For each sh in activeworkbook.worksheets
'
'
'
Next sh

End sub

Thanks a lot,
Hari
India

"Steve" wrote in message
...
Can someone lend some code that will allow me to open each worksheet in my
workbook through code, make a change to the worksheet and move to the next
until all worksheets have been updated. Then let me know the upate has
been
done to all worksheets in the workbook.

Thanks,