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.

ActiveCell.Resize(27,26).copy Destination:= _
Worksheets("outlet summary").Range("A12")

--
Regards,
Tom Ogilvy


"Lee Wold" wrote in message
...
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.