Last in row

[Salata]

Hello,
I have two problems to solve.

First to find last used row in sheet. I was trying looping through column with IsEmpty, but sometimes even if cell is empty and was not touched the result is negative and last row is not really the last one.

Second. How to print quoation marks in message box?
example: Msgbox(" he said "" + sentence + """)

[mrice]

If you know the the longest column, you can use..

Please Login or Register  to view this content.

... where MyColumnNumber is the number of the longest column.

[mudraker]

Please Login or Register  to view this content.

A few methods to get the row/column

Please Login or Register  to view this content.