activecell.copy _
destination:=cells(3,27)

or
activecell.copy _
destination:=range("AA3")

(if I did the translation correctly.)

Stuart Grant wrote:

I thought it should be easy. I'm writing a macro. The first part leads the
Active Cell to a location depending on the value of various (declared)
variables. I then want to copy the value in this cell to another cell on
the same Worksheet. The line in the title doesn't work nor do nor do
various alternatives involving Paste or Select. I always get the dreaded
Error 1004 - and the Help button is totally unhelpful.

Does anyone know how to copy the contents of the Activecell to another Cell
on the same Worksheet?
Stuart

--

Dave Peterson