IF,Then and else??
 

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.

IF,Then and else??
 

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.