xrng

Hi I am trying to compare cells in 2 columns and return the value in the 3rd column on the same Row. This is what I have so far, which is the Ranges I need to use, and have several criteria Compare each cell between Rng1 and Rng2 and if return the value in the xRng Column if: -the cell Value...

I found these two macros on the internet. The first macro works fine. I have no problem with that. What I want is also this: When the check box is ticked, I want the cell that the check box is in to turn green. The second macro only works on one check box. It does not work on all of them...

Hi i have the code below but this works for all of sheet1 and i only want the code to working in column H and down only please can you help for example .Range("H") but i dont know the exact code or where to put it, and i want it to work on new line as well when data entered. I hope you can...

Hey guys i have taken some code from online to create a countdown timer and when it hits 00:00:00 a msg box pops up but i want the box to pop up when the timer hits 00:05:00 (5 min remaining ) can anyone help? thanks Public gCount As Date Sub Timer() gCount = Now + TimeValue("00:00:01")...