What is the syntax for referring to the specified range?
doesn't work.Please Login or Register to view this content.
Thanks.
What is the syntax for referring to the specified range?
doesn't work.Please Login or Register to view this content.
Thanks.
How aboutPlease Login or Register to view this content.
Early in my VBA programming, I tried to use R1C1 notation in the Range("text") method. Unless something has changed, I don't believe the Range("text") method supports R1C1 notation.
When one wants to use integer variables to refer to cells and ranges, one can use the .Cells(row,column) method to refer to a cell. One can also use the .Offset and .Resize methods. This code uses three different methods to define the same rangeIt may be useful to review this, including the examples given of different ways to refer to cells and ranges: https://msdn.microsoft.com/en-us/vba...e-object-excelPlease Login or Register to view this content.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks