Using a For each loop with a column collection

As it is written now, variable cell is assigned whole column at once (not cell by cell). To obtain proper result use:

Please Login or Register  to view this content.

Hi,

You need to specify the .Cells property, otherwise your collection is actually a collection of columns so you are trying to compare the value of the entire column to "RW" in the first (and only) iteration.

Please Login or Register  to view this content.

In the real world you would want to limit the rows, of course.

No, it is not better. Reading the Text property of a cell is considerably slower than reading its Value or Value2 property.

It's a known fact. See for example MVP Charles Williams' blog here- https://fastexcel.wordpress.com/2011...w-to-avoid-it/

Or just try it yourself. Instead of espousing half-baked theories, you may want to actually try the suggestions you're making, as well as tempering the way you propose things to people.

Yeh, It sounds reasonable - if one expects string - why use variant?

But it only sounds well in theory.

If you DO measure, it is just opposite.
Text property looks elegant and appropriate, but it is slow compared to variant value or value2 properties.

Howgh!

And as most of VBA users are not faculty members, working on theoretical aspects of programming, but simple users working on "single or limited use" solutions for their small but time intensive problems, I'd say variant use is just fine.