I recorded a macro and modified it and part of it works great, al
except for the last step. Here is what I'm trying to do.

I need to put the current time in a cell and a little while later pu
the time in the cell to the right. Kind of like a timer.

I recorded a macro that put the function Now() in the cell, then
copy to clipboard, then paste special (values) back in the same cell.
this puts the time back in the cell where its won't recalculate as th
function NOW(). I modified the macro to use the Active.cell whe
pasting so it won't jump to the cell I recorded macro with. that par
works great.

The problem is with the last step... After I paste the first time int
the cell, I want to move one cell to the right. the recorded macr
puts in the cell I use during recording... I need that to be relative
I need to modify to just cursor

I think I need the macro command to cursor once to the right.

the current macro is...

'

'
ActiveCell.FormulaR1C1 = "=NOW()"
ActiveCell.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone
SkipBlanks _
:=False, Transpose:=False
End Sub

What do I add to just move to the right one column?

Thanks
Mar

--
Message posted from http://www.ExcelForum.com