Dear Bob,
I don't get it. Is it a stand alone macro or should be within other lines?
Thanks,
Marisa

"Bob Phillips" wrote:

With ActiveCell
.Resize(4, 4).Cut Destination:=.Offset(1, 0).Resize(4, 4)
End With


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Marisa" wrote in message
...
Hi there,

I am using excel 2002. I want to write a macro to copy an area of cells
(4
rows by 4 columns) to 1 row down. e.g. source cells A1:D4, then
destination
cells be A2:D5.

The starting cell should be the current active cell. Actually the column
is
fixed, always A to D, only the row reference need to be refer to the
active
cell.
How should the macro be?

Thanks a lot!
Marisa