Hi,
I am using following command to find a last non-blank cell in a row:
[vba]Range("A1").End(xlToRight).Select [/vba]It works fine most of the time. But sometimes, the result is unexpected.
For instance, when I delete the values in the row, it gets confused.
Anyone has a better solution for fiding the last non-blank cell?
Thanks,
Arash