Help with Macro

Lost and Confused - Aug 3, 2009 at 01:25 PM
 Lost and Confused - Aug 18, 2009 at 11:54 AM

I am trying to write an if statement into a macro. Basically, if the users active cell is not in a certain range I do not want the macro to work... the user should get a msg that say place cursor in the appropriate area.

If the cursor has been placed appropriately, then I would like for the macro to continue on into the next line of code.

Can anyone help me accomplish something like that.

Lost and Confused

3 replies

Macro Ignorant
Aug 14, 2009 at 09:54 AM
I also need a solution for this problem... can any solve this one? I want to restrict the cells that my macro works within by checking the active cell cursor position. If the active cell is not within a range of cells then the macro should end.

Try an if else statement with an activerange.
Lost and Confused
Aug 18, 2009 at 11:54 AM
I'm not sure how to create an If/Else statement for an activerange. Can anyone point me in the right direction?