Macro to change only cells where colorIndex =15

update: I have pasted the whole subroutine at the bottom of this post please advise. Thanks.

The if statement changes the whole spreadsheet format to m/d. However,
I Need it to change only cells where colorIndex = 15. Please tell me what I am doing wrong here. Thanks. MC

Please Login or Register  to view this content.

try this:
you can change the range to my range

Please Login or Register  to view this content.

I tried the above code. It did not work. The message box did however display "If statement is True".
Because the column ranges change per worksheet in the workbook. I could not hard code a range. I am using code to select the whole worksheet. In the worksheet there are random date rows and then number rows such as:

6/5 6/6 6/7 6/8 <-- grey interior
Tue Wed Thu Fri <--grey interior
0 0 0 0/8
8 0 0 0
8 8 8/8 8
8 8 0 8

Some numbers are generated as date format, which I do not want if they are not meant to be a date because these are hours of employees. The worksheet is very large and I cannot monitor the way the user inputs the numbers. :-( Anyway, I will paste all my code in the bottom of this. Please your help is SOOOO appreciated. -Mitchell.

Please Login or Register  to view this content.

mitchellCo,

Please read forum rules below and then wrap your code otherwise this thread will be locked or deleted

VBA Noob