Posted to microsoft.public.excel.programming

Kent McPherson[_3_] Kent McPherson[_3_] is offline

external usenet poster

Posts: 11

moving to next worksheet

Tom Ogilvy wrote:
Sub AA()

Set sh = ActiveSheet
On Error Resume Next
Do While sh.Next.Visible < xlSheetVisible
If Err < 0 Then Exit Do
Set sh = sh.Next
Loop
sh.Next.Activate
On Error GoTo 0

End Sub

Thanks! Works perfectly.

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
Moving within the worksheet	ordnance1	Excel Worksheet Functions	3	March 28th 08 03:45 AM
Moving a Worksheet	jpiseler	Excel Discussion (Misc queries)	6	September 6th 07 01:10 AM
moving a worksheet..?	Roy	Excel Discussion (Misc queries)	2	September 29th 06 02:56 AM
Moving between the tabs on a worksheet	Sarah B	Excel Discussion (Misc queries)	3	April 11th 06 12:16 PM
Need help i moving one worksheet to another	psk[_7_]	Excel Programming	1	November 12th 04 04:00 PM

All times are GMT +1. The time now is 10:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us