Mar 28 2020 04:43 PM
I want to write a macro to insert the text Ok in red into a cell coloured yellow. I have made the macro but cannot get it to work in the cell i nominate, it will only work in the cell i created it in.
This is my first macro so it is probably easy for some of you.
Mar 28 2020 05:13 PM
You can update the location of the entry by changing the code in VBA editor (Alt + F11).... you are looking for something along the lines of:
Range("A1")........
Just change to the cell that you want it.