Posted to microsoft.public.excel.programming

John Ortt

external usenet poster

Posts: 4

Creating and using an array

Far better,

Thanks Bob.

"Bob Phillips" wrote in message
...
Is this any better for you

CopyData Worksheets(2).Range("P1"), Worksheets("Menu").Range("I:I")
CopyData Worksheets(2).Range("A1"), Worksheets("Menu").Range("J:J")

'...

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
creating an array	Richard	New Users to Excel	4	March 15th 07 01:06 PM
creating an array	Richard	Excel Worksheet Functions	4	March 15th 07 01:06 PM
creating an array from range help	Gary Keramidas	Excel Programming	5	August 13th 06 02:48 AM
creating an array on the fly	Gary Keramidas	Excel Programming	4	August 9th 06 09:34 PM
Creating an array	Eric[_6_]	Excel Programming	1	January 12th 04 08:25 PM

All times are GMT +1. The time now is 09:41 PM.

About Us

"It's about Microsoft Excel"