Ignore formulas

  • Thread starter Thread starter mushy_peas
  • Start date Start date
M

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.
 
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.
 
Back
Top