afzalw
04-15-2013, 08:59 PM
I got this code who do I find the RowNumber of rDest variable and put it in this code.
Set rDest = Sheets(5).Range("I" & Rows.Count).End(xlUp).Offset(1, 0)
rDest.Resize(1, 1).Value = "=CV" & RowNumber of rDest
This code is moving same data from same sheet in same from same row in a different column for that I used formula in each cell
=CV1
=CV2
=CV3
=CV4
Thanks
Set rDest = Sheets(5).Range("I" & Rows.Count).End(xlUp).Offset(1, 0)
rDest.Resize(1, 1).Value = "=CV" & RowNumber of rDest
This code is moving same data from same sheet in same from same row in a different column for that I used formula in each cell
=CV1
=CV2
=CV3
=CV4
Thanks