Comparison of Columns VBA

[Finalfight40]

Hi All

I am working on some vba and i haven't got to the point where i will need this yet but i know it will be useful.

I am looking to compare 2 columns lets say A and B where they contain values (Not empty) and the length of the columns are always different. (A and B will be the same length as each other)

The data would start in A2 and B2. If A2 is less than B2 it would format the cell Red.

I know i can do it with a do until isempty(activecell) loop but i know that will be very long and not the most efficient way.

Thanks

 

[Johnny C]

Wouldn't conditional formatting be easier?

 

[Finalfight40]

It would be a macro for someone else to use once they get some raw data. They just want to press a button and it does everything for them basically.

 

[Joe4]

Just create a Macro to set up Conditional Formatting to do that on the whole range. No loops required.
You can get a lot of the code you need for that by recording yourself setting up Conditional Formatting to do that.
You would just need to generalize the data range to account for an unknown number of rows, but that isn't hard to do.

For example, to find the last row with data in column A, you could use this:

Dim lastRow as Long
lastRow = Cells(Rows.Count,"A").End(xlUp).Row

 

[Finalfight40]

Just create a Macro to set up Conditional Formatting to do that on the whole range. No loops required.

Ooo that would work, thanks Joe4.

Also if that is what you were trying to explain to me Johnny, sorry but i misunderstood.