PDA

View Full Version : [SOLVED] Row Number of Cell



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

mikerickson
04-15-2013, 09:19 PM
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
04-15-2013, 09:34 PM
Thanks, I did not knew about object browser.
I was using row.count and getting confused.