Help with MacroClosed

Question

Hello,

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.

Thanks,
Lost and Confused

Macro Ignorant · Answer

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.

thanks,

Wiz · Answer

Try an if else statement with an activerange.

Lost and Confused · Answer

I'm not sure how to create an If/Else statement for an activerange. Can anyone point me in the right direction?

Help with Macro

3 responses

Similar discussions

Subscribe To Our Newsletter!