Hello All,
I'm struggling with the following.
In a worksheet I define a subrange with 2 cells, c1 and c2 like c3 = range (c1, c2). Then, in that subrange I need to find the bottom right used cell (last used cell). Typically this is what is returned by UsedRange in a worksheet.
Thus to find that "last used cell" in my subrange only, I've tried using SpecialCells(xlCellTypeLastCell) which is supposed to apply on a range (not on the whole worksheet).
Unfortunately, when I use SpecialCells(xlCellTypeLastCell) on my subrange c3 I have the same result as if I apply it in the whole worksheet :/
How can get the "last used cell" of my subrange without regard to the complete worksheet ? All cells out of my subrange have no interest in my case...
Any highlight will be very welcome...
Thanks,
Alexandre
Bookmarks