Is there a way to resize multiple ranges at once.
I have the following code:
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
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