Posted to microsoft.public.excel.programming

Utkarsh Majmudar[_2_] Utkarsh Majmudar[_2_] is offline

external usenet poster

Posts: 5

Looping through Sheets

Thanks to all those who helped. Resolved the problem with the following
code that I found on a posting:

****************

Dim sh As Worksheet
For i = 1 To Sheets.Count
Set sh = Sheets(i)
sh.Activate

'My voodoo stuff here

Next i

*****************

Utkarsh

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looping between sheets picking up values on the way	bungie	Excel Worksheet Functions	3	March 5th 06 07:22 AM
Looping through Sheets	dalejrstwin	Excel Programming	0	September 24th 04 06:43 PM
looping every third row	Jason Hancock	Excel Programming	5	July 1st 04 08:00 PM
Looping through Sheets and passing values to an Array	Michael Rhein	Excel Programming	2	February 13th 04 10:54 AM
Looping through sheets	Eric[_7_]	Excel Programming	1	July 24th 03 04:45 PM

All times are GMT +1. The time now is 08:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us