Conditional Highlighting of Rows

[bakeraj256]

Hi,

I have a program that compiles a whole bunch of annual data.

The data is in columns A:J

I would like to have a program that loops through column A's entries and if the entries are odd then have the cells in Columns A through J of that row be highlighted with colour index RGB (193, 205, 205).

This is what I have below, but it is not working and I am having trouble finding online guidance.

Thanks,

Please Login or Register  to view this content.

[mrice]

Try

Please Login or Register  to view this content.

[bakeraj256]

Hi,

So I just tried this, but my debugger prompts me claiming there is still an error in the line:

Please Login or Register  to view this content.

Any thoughts?

[mrice]

Try

Please Login or Register  to view this content.

ColorIndex just allows a limited number of integer values

[bakeraj256]

Made the change, but still no luck.

Sorry to be pestering.

[mrice]

How is lrow defined? Are you sure that it has the correct value? Suggest putting a breakpoint on the second line and hovering over lrow to see what value it has.

[bakeraj256]

lrow is defined in an earlier procedure of the program. I have included the snipits of the earlier procedure:

Sorry, I am very new to VBA, so when you suggest putting a breakpoint on the second line and hovering over lrow, I'm not sure how to execute that.

Thanks all the same.

Please Login or Register  to view this content.

[PCI]

Something a bit long but it seems working

Please Login or Register  to view this content.

[bakeraj256]

Thank you this worked wonderfully.

Now I will have to sit and go through it to figure out exactly what it is doing

Thanks so much.