Row Number of Cell

[afzalw]

I got this code who do I find the RowNumber of rDest variable and put it in this code.



[vba]
Set rDest = Sheets(5).Range("I" & Rows.Count).End(xlUp).Offset(1, 0)
rDest.Resize(1, 1).Value = "=CV" & RowNumber of rDest
[/vba]
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

[mikerickson]

The .Row property of a range object will give you the row number of the upper left cell of that object.

When I started writing VBA, I would spend forever going through the Object Browser looking at the properties of an object until I found something that I could use.

[afzalw]

Thanks, I did not knew about object browser.
I was using row.count and getting confused.