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.