Posted to microsoft.public.excel.programming

Knox

external usenet poster

Posts: 45

moving through sheets in a loop

Thank You!

" wrote:

You have i in quotes, which makes it a string - try it as

sheets(i).select

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 Data between sheets in the same workbook and moving data between Workbooks.	Alison Brown	Excel Worksheet Functions	0	February 10th 09 01:03 AM
Loop in sheets	al007	Excel Programming	4	November 28th 05 03:07 PM
Loop through sheets	michael	Excel Programming	2	September 8th 04 02:52 PM
Moving through sheets	Keith Emery	Excel Programming	2	June 22nd 04 01:53 PM
Loop across Sheets and number of sheets	Raj[_8_]	Excel Programming	2	December 18th 03 09:18 AM

All times are GMT +1. The time now is 12:15 PM.

About Us

"It's about Microsoft Excel"