Posted to microsoft.public.excel.programming

merjet

external usenet poster

Posts: 812

Problems populating an array

Maybe you need to qualify the Range, e.g.:
Worksheets("Sheet1").Range("F" & LstRowNdx + 14).Value
Without the qualification, Excel assumes the active sheet.

HTH,

Merjet

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
Populating an array	Bucs85027	Excel Worksheet Functions	0	February 14th 08 12:32 AM
Populating a dropdown list with an Array	MC[_3_]	Excel Programming	3	March 4th 04 05:32 PM
Populating a 2-D array	Hotbird[_2_]	Excel Programming	8	February 7th 04 05:25 PM
Populating a Temporary Array	Pete	Excel Programming	6	January 14th 04 01:57 PM
populating multicolumn listbox with an array instead of...	notsureofthatinfo	Excel Programming	0	November 5th 03 10:18 PM

All times are GMT +1. The time now is 08:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us