Select an array of cells and paste to separate worksheet - 2nd post - 1st didn't work!!
 

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.

Select an array of cells and paste to separate worksheet - 2nd post - 1st didn't work!!
 

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.