Posted to microsoft.public.excel.programming

ReportSmith ReportSmith is offline

external usenet poster

Posts: 34

Looping through sheets

I have code (Excel 2000) that loops through all the visible sheets in a
workbook. Problem is, when the code gets to the "next.sh" line, the next
worksheet is not selected.

For Each sh In mybook.Worksheets
if sh.visible = xlsheetvisible then

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 thru Sheets without activating	Myles[_19_]	Excel Programming	10	December 30th 05 04:05 PM
Looping through Sheets	Jim Thomlinson[_3_]	Excel Programming	3	September 25th 04 03:48 AM
Looping through Sheets	dalejrstwin	Excel Programming	0	September 24th 04 06:43 PM
Looping through sheets	Eric[_7_]	Excel Programming	1	July 24th 03 04:45 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us