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. 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!![]()
Please Login or Register to view this content.
Bookmarks