Posted to microsoft.public.excel.programming

Gary Keramidas[_2_] Gary Keramidas[_2_] is offline

external usenet poster

Posts: 364

need some help with selecting a sheet in a loop again

i have tabs renamed, so i am using this

For c = 2 To 13

Sheet2.Range("C5:E5").Copy
Range("C5:E5").PasteSpecial xlPasteValues, xlPasteSpecialOperationAdd '
(this range is on sheet1)
Next c

i want to replace the 2 with the c so it selects the range of sheets from 2
to 13.

any help appreciated
--

Gary

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
Ignoring Sheet in For Each Loop	ExcelMonkey[_190_]	Excel Programming	3	March 3rd 05 10:09 PM
Jump out of Do Loop on sheet change	Paul	Excel Programming	2	May 14th 04 04:21 PM
Loop - for each sheet not working?	Shetty	Excel Programming	6	January 15th 04 02:22 PM
Another loop & sheet question	steve	Excel Programming	4	November 25th 03 02:12 PM
Excluding sheet in loop	david	Excel Programming	2	July 31st 03 03:18 AM

All times are GMT +1. The time now is 07:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us