Do...Loop, help 
Author Message
 Do...Loop, help

Hi
 New at this, not sure if I am in the right group but maybe someone can
help!

I am using VBA in MS Excel and trying to use an Do....Loop and a
"IF.....Then....Else.........statement.
I am trying to get the macro to check if it is at a certain cell on the
spreadsheet, if so, to exit sub.

I have used    If ActiveCell = Blank Then     and that works, but when I try
writing   If ActiveCell = Range("A17") Then.....or    If ActiveCell =
"R17C1" Then......or    If ActiveCell = "=R17C1" Then      it either exits
the sub from any cell or ignored the statement. Is there a way to tell the
macro, in a Do...Loop and a IF....Then....Else...... statement so that it
will know which cell it is in ?

If anyone can help my Thanks in advance.
Bob



Fri, 30 May 2003 03:16:19 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. While Doing Loop Goto Exit and Do Wend

2. using a command button to change what a loop is doing

3. do loop is doing me in = (

4. NEWBIE HELP - Do-loop while loop

5. Help, Help, Help: Endless Msgbox loop

6. ADO thinks DBMS is done, but DBMS ain't done

7. HELP HELP Message Loop

8. Loop within a loop

9. loop de loop

10. Exiting loops and for/next loops

11. my loop doesn't loop!

12. do ... loop looping

 

 
Powered by phpBB® Forum Software