| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing an IF/Then Statement in VB based on entry in a cell
I have defined the following value for a cell within my macro
Range("K" & i).Select ActiveCell.FormulaR1C1 = _ "=((YEAR(RC[-1])-YEAR(RC[-2]))*12)+(MONTH(RC[-1])-MONTH(RC[-2]))" If the value of this range is 0, I want to do other things. I'm not sure how to write an "IF" statement to capture this information. How do I do that? Thanks in advance, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Force entry into cell, based on validation selection in adjacent cell | Excel Worksheet Functions | |||
| Writing a macro to hide columns based on cell value | Excel Discussion (Misc queries) | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
| Input boxes - writing entry to cell | Excel Programming | |||
Threaded Mode
