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