Gurus,
when i turn a table to a range and try xlup, the cell selection stops at the last non blank cell.
However when I turn a table from external data source, in my case from PDF, to a range, and do xlup the cell selection stops at the cell at the last row regardless. So how come there's this minor difference? BTW if I alt h e a the blank cell it still does the same thing. I need to know the root cause for doing some macro recording. Thanks in advance!
when i turn a table to a range and try xlup, the cell selection stops at the last non blank cell.
However when I turn a table from external data source, in my case from PDF, to a range, and do xlup the cell selection stops at the cell at the last row regardless. So how come there's this minor difference? BTW if I alt h e a the blank cell it still does the same thing. I need to know the root cause for doing some macro recording. Thanks in advance!