Hiya,

This seems odd. I want to concatenate a cell address but I get an error: Run-time error '1404'; Method 'Range' of object '_Global' failed.

here's my code:
dim intCount as integer

intCount = 2
strCellValue = Range("A" + Str(intCount)).Value 'This throws the error

strCellValue = Range("A2").Value 'This works!

I tried changing my variable type to variant but no such luck. Any ideas?

Cheers,
John