Ignore formulas

[mushy_peas]

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.

 

[Tom Ogilvy]

No, if the cell isn't empty, it will go to that cell.

You might be able to achieve what you want using specialcells, but it sounds
like you want to find the next available cell with available meaning it
appears empty although it may contain a formula returning a null string or
it may actually be empty. I think to resolve that, you would need to loop
through the possibilities and see which appear to be blank.

 

[mushy_peas]

Cheers Tom Ogilvy.
Back to the drawing board for me then.
THank