Macros

Copper Contributor

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.

1 Reply

@ColinK 

 

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.