After doing a find for a specific text, I would like to say the following,
but in actual excel langague:

If ActiveCell = "A5" Then Range("A1:G4").Select Else Range("A1:G6").Select

I know this is wrong as it's looking for the text A5 instead of the Cell A5,
does anyone know how to remedy this?

Thanks..... Alastair.

Hi

If ActiveCell.address = "$A$5" Then

The 'address' property returns absolute reference by default.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Alastair79" wrote:

After doing a find for a specific text, I would like to say the following,
but in actual excel langague:

If ActiveCell = "A5" Then Range("A1:G4").Select Else Range("A1:G6").Select

I know this is wrong as it's looking for the text A5 instead of the Cell A5,
does anyone know how to remedy this?

Thanks..... Alastair.