Posted to microsoft.public.excel.programming

Steph[_6_] Steph[_6_] is offline

external usenet poster

Posts: 92

Visible sheets

Hello. The bwlow snippet of code return each sheet in a workbook. Is there
a way to return on sheets that are visible? Thank you!

For Each sh In bk.Worksheets
ThisWorkbook.Worksheets("Sheet Verify").Cells(cell.Row, j).Value =
sh.Name
j = j + 1

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
3 sheets in workbook, but visible only one?	slaya_cz	Excel Discussion (Misc queries)	3	September 30th 05 01:37 PM
Printing all Visible sheets	Darin Kramer	Excel Programming	2	March 30th 05 05:38 PM
visible sheets	Bombermanx	Excel Programming	3	November 12th 04 02:03 PM
HELP!! Cannot set any sheets to visible	cassidyr1[_4_]	Excel Programming	1	October 27th 04 02:19 PM
HELP!! Cannot set any sheets to visible	cassidyr1[_3_]	Excel Programming	1	October 26th 04 06:36 PM

All times are GMT +1. The time now is 09:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us