ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Active Cell (https://www.excelbanter.com/excel-programming/295976-re-active-cell.html)

Juan Pablo González

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





All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com