Using For Each Cell in Range() with .SpecialCells(x1CellTypeVisible) does not work

[lordterrin]

I have a sheet with 60,000 lines on it. By doing a simple sort, I can take out about 40,000 that I don't actually want information from.

As these cells are imported from a different program, they contain a ton of spaces at the end, and I need to trim those off so they're viable for vlookup. I have the following code:

Please Login or Register  to view this content.

This works fine - but it runs on all 60,000 cells and causes me to age by a year each time I run it.

What I'm trying to do is this:

Please Login or Register  to view this content.

But alas, I get an error.

[shg]

Maybe ...

Please Login or Register  to view this content.

[Olly]

Try:

Please Login or Register  to view this content.

[lordterrin]

Try:

Please Login or Register  to view this content.

This does work, technically - but I'm not sure what the celltypeCosntants does - it still hits all cells from 1 - 60,000, even the hidden ones.

[JOHN H. DAVIS]

Can this help?

Please Login or Register  to view this content.

[Olly]

Ok, so try:

Please Login or Register  to view this content.

Limited to visible cells within the used range of column F.

Check the worksheet reference.

[lordterrin]

Ok, so try:

Please Login or Register  to view this content.

Limited to visible cells within the used range of column F.

Check the worksheet reference.

Pardon my ignorance on this - but I'm not sure which value to change to get it to work with my sheet.

It runs without error, but it doesn't do anything. The name of the sheet I'm working is Start. So I tried changing this to:

Please Login or Register  to view this content.

None of them work.

[Olly]

Pardon my ignorance on this - but I'm not sure which value to change to get it to work with my sheet.

It runs without error, but it doesn't do anything. The name of the sheet I'm working is Start. So I tried changing this to:

Please Login or Register  to view this content.

None of them work.

I was referring to the codename. You could equally use:

Please Login or Register  to view this content.