View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spuds Glorious Spuds[_2_] Spuds Glorious Spuds[_2_] is offline
external usenet poster
 
Posts: 5
Default Execute macro when active cell is in a defined area

Hi all

I am completely inept at writting code for macros - most of my stuff is for
repetitive task such as cut copy & paste
For one such macro is there any way a code can be added so that the macro
will only execute if the active cell is in a defined range say A1:G10 but if
the active cell is not in this range go make cell A1 active??

Much appreciated