Ignore formulas
 

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/

Ignore formulas
 

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.

--
Regards,
Tom Ogilvy

"mushy_peas " wrote in message
...
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/

Ignore formulas
 

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

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