Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Got it.
Had to change: vaData = Range(ActiveWindow.RangeSelection.Address).Value to: vaData = Worksheets(2).Range(ActiveWindow.RangeSelection.Ad dress).Value I was pulling data off the first sheet instead of the second. The first sheet has no values for the first 3 columns so it filled my array with empty values. It's odd because the line right before it works and selects the correct cells on the second sheet but then feeds the array from the first sheet without specifying which sheet to go to and copy into the array. Hope this helps someone else in the future. Jerry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
paste values from an array to a range | Excel Programming | |||
adding range values to array | Excel Programming | |||
Store range of values in an array | Excel Programming | |||
range values in an array? | Excel Programming | |||
Array of Values from Worksheet Range - What does it 'look' like? | Excel Programming |