xldown

Hi, I have values from B1 to B275 but the list will be updated and so the last row will be changed frequently. I intend to select the range such that only the cells in column B with values are contained in the range. I know that the syntax for this is xldown but how do I implement it?

My original code

Please Login or Register  to view this content.

. Now this ISIN is the name for the range, to be specific, Column B. But I only want to restrict the range to the cells in column B with values. How do i do this using xldown? Thanks!

Hi secondrate
Something like....

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I like:

Please Login or Register  to view this content.

Quicker than a loop, try Specialcells

Please Login or Register  to view this content.

You usually don't need to Select though