R1C1 with Variables

[kaplin]

When I do this:

text = "=subtotal(9," & Chr(64 + col) & "2:" & Chr(64 + col) & lastrow & &quot"

where col and lastrow are integers, I get an error because it inserts single parenthesis into the formala in the cell.

Ex: =subtotal(9,'A20':'B60')

Any idea how I get rid of the parenthesis - am I concatinating wrong?

 

[Zathras]

Double post. See response in thread68-526844.