Looking for a little syntax help.
I'm writing an excel module that will scan each cell for a date. If the date is not equal to today's date then I would like to highlight the entire row grey.
So far I was thinking something along the lines of the follwing:
Because this is my first time doing vba (I was a java programmer) I will have to use psuedo code.
If Sheet1.(Range("Current Cell")) != date(today) Then
Rows("current row").Interior.ColorIndex = 15
Also If anyone knows an excel vba command reference site or listing that would be helpful as well.