Posted to microsoft.public.excel.programming

Jim at Eagle Jim at Eagle is offline

external usenet poster

Posts: 83

Loop thru worksheets(i)

Dim i As Byte
i = 22
Do While i < 32
Worksheets(i).Range("J14:K28").ClearContents
i = i + 1
Loop

I have tried many ways but allways get one of several errors when the
worksheet line is run. Any help here will be greatly appreciated.
--
Jim at Eagle

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
Naming Worksheets - Loop within a loop issue	klysell	Excel Programming	5	March 29th 07 05:48 AM
Naming Worksheets - Loop within a loop issue	klysell	Excel Programming	0	March 27th 07 11:17 PM
(Complex) Loop within loop to create worksheets	klysell	Excel Programming	1	March 20th 07 12:03 AM
Loop Through worksheets	Stephen[_9_]	Excel Programming	5	April 20th 04 01:46 PM
Loop worksheets	Steve[_35_]	Excel Programming	3	November 25th 03 04:46 AM

All times are GMT +1. The time now is 05:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us