Thread: Active Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Active Cell

Post the code please.

In general, replace
Range("Z14").Whatever
with
ActiveCell.Whatever
but post the code for an exact answer.

HTH. Best wishes Harald

"McChas" skrev i melding
...
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