Thanks Doug, will try it out

--

Regards
Michael Koerner


"Doug Glancy" wrote in message
...
Michael,

Destination:=Activecell

hth,

Doug

"Michael Koerner" wrote in message
...
I have recorded a macro using the record Macro feature in Excel I would
like to know how I can change the following code to reflect the current
cell which the cursor is in.

Destination:=Range("B689"))

--

Regards
Michael Koerner