Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting and Worksheet_Change
Hi There,
I am new here so let's see... I am having hard time trying to make VBA code. I am trying to make a code that will check range B4:AZ4 and if there is a value 7, it will make cells from row 5 to row e.g. 500 "7" coloured as grey. I am able to get this far, but it should work out when there are changes in rows 5 to 500. I want it work when I drag and drop/enter values/delete values to run this. Please, Help me, I am going nuts over this.... Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_Change | Excel Programming | |||
Worksheet_Change | Excel Programming | |||
More Then one Worksheet_Change | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming |