Hi All,
In my code I have chosen the last row in col A as cut it. Now I want
to advance one column in the same row line and paste this value.

Here is my code:

lRow = .Cells(.Rows.Count, 1).End(xlUp).Row
..Cells(lRow + 0, 1).Select
Application.CutCopyMode = False
Selection.Cut
i want to go one col to right in the same row and paste it. I am
trying it for long but cannot get it to work.

Appreciate your help.
Thank you
Syed Aziz


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=503019