Resolved >>>For Loop not finishing.

Hello,

I have the following code. I am trying to conditional format a row based on the value of the A column of the row.I have a total of 3 rows.

I have to use VBA because in time I may have 4 rows of data

The problem is I after the first do while loop the code stops and the code doesn't proceed to format row 2.


Can anybody help.I have also attached the excel sheet

Thanks

Please Login or Register  to view this content.

the reseaon is that the activecell keeps moving accros the first row as you carry out the formating and so does not get back to the column A do do the subsequent evaluations

try the following

Please Login or Register  to view this content.

Does that work

Regards

Dav

Thanks
Problem solved once variable declared