Resizing Ranges

sheri100

New Member
Joined
Mar 29, 2010
Messages
15
Is there a way to resize multiple ranges at once.

I have the following code:

Code:
ReDim MTHHead(1, nMthsVint)
    MTHHead = Sheets(strCMWtsD).Range(cellLoc).Resize(1, nMthsVint).VALUE
    
   ReDim inTable(nRows, nMthsVint)
   inTable = Sheets(strCMWtsD).Range(vNewRange).Resize(nRows, nMthsVint).VALUE

cellLoc and vNewRange are cell locations derived from user inputs

MTHHead returns a range of dates base on user inputs.
inTable returns a range of dates and data based on a user input

The data being returned needs to start at the first date in MTHHead, the way I have it now the data being returned is the first value in the range I'm reading from.

Any help would be appreciated.

Thanks
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,108,579
Messages
5,523,705
Members
409,531
Latest member
Lmfacc

This Week's Hot Topics

Top