Last non-blank cell in a row or column

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

try

Code:

---

cells(1,columns.Count).end(xltoleft).select

---

Thanks venkat.

Cheers.