Thread: Active Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default Active Cell

Replace any instance of code that is like

Range("A1")

with

ActiveCell

--
Regards,

Juan Pablo González

"McChas" wrote in message
...
Hi all, I have a macro (shortcut key) that when run it will insert a

checkmark symbol in the current cell. I have made a few attempts at this but
when the macro is run, it inserts the checkmark into the original cell when
the macro was created.

any suggestions or help would be greatly appreciated