There is a property in Excel vba to get the bottom most cell used. however sometimes it thinks its used and its not


So I'd recommend the following:
Make sure you have a column that is guarenteed to have data.
from the lowest cell in that column do the end+up combo.
You should now be on the lowest row of data.

You can record this action in a macro to see how it works. Should be something like:
Code:
msgbox "Bottom Row : " & sht.cells(65000,1).end(xlup).row
From in excel. The sht is the worksheet, xlup is a constant, you can get this from the immediates windo in excel vba.

You can also come from above, but if you only have a title row it is not helpful.
Does that help?