L
Lee Wold
Help for a novice please!!
On the active worksheet I want to be able to select a single cell and then
assign a macro (that I will run from CTRL A) to select an array of cells
that is 26 columns wide by 27 rows deep from that single cell) and copy that
selection to a worksheet entitled "outlet summary" to cell A12.:Z38.
e.g. I select cell A435 on the active sheet and when I press ctrl A it will
copy the array of cells ref A435:Z461 (i.e. 26 columns by 27 rows where the
cell selected is top left cell) to worksheet "outlet summary" into cells
A12:Z38.
I know this is probably very simple but I am struggling to identify the cell
reference of the selected cell in VBA.
Would very much appreciate some help.
Thanks in anticipation.
On the active worksheet I want to be able to select a single cell and then
assign a macro (that I will run from CTRL A) to select an array of cells
that is 26 columns wide by 27 rows deep from that single cell) and copy that
selection to a worksheet entitled "outlet summary" to cell A12.:Z38.
e.g. I select cell A435 on the active sheet and when I press ctrl A it will
copy the array of cells ref A435:Z461 (i.e. 26 columns by 27 rows where the
cell selected is top left cell) to worksheet "outlet summary" into cells
A12:Z38.
I know this is probably very simple but I am struggling to identify the cell
reference of the selected cell in VBA.
Would very much appreciate some help.
Thanks in anticipation.