Xlup question

[yxz152830]

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!

 

[jasonb75]

the cell selection stops at the last non blank cell.

It actually stops a the last empty cell. When you copy from an external source there might be some blank cells at the end which are not actually empty but contain null strings.
To find the last non blank which may not be empty, you would need to use this method instead.

Set rng = Range("A:A").Find("?*", , xlFormulas, xlWhole, , xlPrevious, False, False, False)

 

[yxz152830]

What are null strings and how do I put null strings in a cell?
the code you wrote gave me the last "visually non blank " cell.

It actually stops a the last empty cell. When you copy from an external source there might be some blank cells at the end which are not actually empty but contain null strings.
To find the last non blank which may not be empty, you would need to use this method instead.

Set rng = Range("A:A").Find("?*", , xlFormulas, xlWhole, , xlPrevious, False, False, False)

do

 

[jasonb75]

What are null strings and how do I put null strings in a cell?

They are padding that makes an empty cell appear occupied, among other ways you can put them in cells by using .Value = vbNullstring or by converting formulas that show blanks to values.

the code you wrote gave me the last "visually non blank " cell.

That is correct.