View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dmoney Dmoney is offline
external usenet poster
 
Posts: 42
Default Simple questions (I hope)

First and second condition must be explicit. based on
your code, I believe what u are trying to achieve should
be done using the and operator -- meaning check this
condition and this condition.

Try this

If ActiveCell.Row < 1 And ActiveCell.Row < 2 Then



-----Original Message-----
1) In Column A:A I want to select A3: the last cell in

that column with data
in it (non-empty cell).

2) On this code = [ If ActiveCell.Row < 1 Then ] I

want to expand it to
If ActiveCell.Row < 1 or 2 Then. But the "or 2" is

throwing things off???
.