i have this line which finds the next available cell in a certain
colum.
ActiveSheet.Range("b60000").End(xlUp).Offset(1, 0).Select

is there a way to get it to ignore formulas too.

Cheers in advance.


---
Message posted from http://www.ExcelForum.com/