Select from second row to last in column A - problem

[nkehayova]

Hello guys,
I have a problem with selecting cells from A2 to A(last row) in a macro.
In short - I filter a specific value, then walk all filtered values (unique ID in column A) and do something with them.

I use this:

Please Login or Register  to view this content.

It works in the general case, but as far as I can see, when the last row is 2, the selected range breaks and the loop starts walking through all visible cells (A1last possible cell in excel)).
Do you have any ideas how to avoid this?

[ARowbot]

Try using:

Please Login or Register  to view this content.

[Arkadi]

Try replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Does that help at all?

[nkehayova]

Hi guys,

I found out that when a single cell is selected, and the property Specialcells is used, excel searches the whole workbook.
I worked around it by:

Please Login or Register  to view this content.

It works just fine now.