Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Macro
I have a worksheet set up, along with a macro. It changes the value of
column G, but only if column T does not contain the letter "N". If column T DOES contain the letter "N", then column G is unchanged The code below only works if the letter N is uppercase. I want to change to code to look for both uppercase and lower case "N". If .Cells(X, "G").Value 0 And .Cells(X, "G").Value < 0.1458333 And ..Cells(X, "T") < "N" Then .Cells(X, "G").Value = "3:30" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |