Merge 2 VBA into 1

[keith740]

hello Forum... i know very little of VBA... i do have these 2 codes in which i need in 1... any help is greatly appreciated

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[GC Excel]

Hello, can you try this:

Please Login or Register  to view this content.

[keith740]

welll.... it did work, but it highlighted the cells on sheet 2 which is titled "Log"
Can we highlight sheet 1 titled "Incident"

[GC Excel]

It wasn't clear....

Simply change this part:

Please Login or Register  to view this content.

[keith740]

Perfect TY so much GC Excel!

I have 1 more issue i need help with (not sure if a new thread would be appropriate since it is similar)

I would like this piece of code to be attached to a 2nd button and the red cells go back to normal.

Please Login or Register  to view this content.

[keith740]

so as to remove the red cells... we could overwrite with white or remove fill... whichever is easiest

[GC Excel]

To remove fill on a range, you can use this:

Please Login or Register  to view this content.

[keith740]

perfect... TY guys!