-
Row Number of Cell
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
-
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.
-
Thanks, I did not knew about object browser.
I was using row.count and getting confused.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules