| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the R1C1-style notation in Macro Language?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what is the R1C1-style notation in Macro Language?
how about
range(cells(1,2),cells(2,5)) -- Don Guillett SalesAid Software "Vincent" wrote in message ... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what is the R1C1-style notation in Macro Language?
When using cells, it refers to the row and column in the following way:
cells(row_number, column_number) So if you update your code to: Range(Cells(1, 2), Cells(2, 5)).Select then this will select the cells B1:E2 cells(1,2) = B1 and cells(2,5) = E2 Hope this helps. FunkySquid Don Guillett wrote: how about range(cells(1,2),cells(2,5)) -- Don Guillett SalesAid Software "Vincent" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
| can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
| Range R1C1 notation & the problem with my Macro | Excel Programming | |||
| Using Range with R1C1 notation in a macro | Excel Programming | |||
| Macro records in R1C1 style | Excel Programming | |||
Linear Mode
