IF,Then and else??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
How to work with reference unions (A1,A3,A5)? 4
copy only value and not formula 3
Code Works Fine in Excel 2007, Excel 2000 generates Runtime Error 438 0
Code arrangement 3
Macro triggered by a cell value change 5
go to specific cell using drop down box 4
if iserror then value = zero problem 1

Back
Top