Find Next Blank Row

[lintz]

Currently I use a loop to find the first blank row but as more and more data is entered into the spreadsheet the loop takes a long time to complete.

I used the below but it gives me an error. Can any offer some sample code to find the first blank row without using a loop.

LastCompletedRow = objExcel.Range("AX:AX").End(xlDown).Row

Thanks.