what is the R1C1-style notation in Macro Language?
 

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
...

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
...