ControlSystems
New Member
- Joined
- Aug 16, 2009
- Messages
- 16
I need to copy data from an array of cells using a variable to define the location of the array:
example I need to copy an array 10 cells wide by 10 cells deep from a spread sheet to another but the start location may be A10 thru A100
depending on the variable locate as a value in an adjacent cell.
the current code used to do this copy always targets the data in the same cells A10:J20. I need this to be shifted by a variable to anywhere in the spread sheet colum A by changing the value located in another cell.
example I need to copy an array 10 cells wide by 10 cells deep from a spread sheet to another but the start location may be A10 thru A100
depending on the variable locate as a value in an adjacent cell.
the current code used to do this copy always targets the data in the same cells A10:J20. I need this to be shifted by a variable to anywhere in the spread sheet colum A by changing the value located in another cell.