Last used column with data - ignoring formulas

[vaclavvesely]

Hi, I have a spreadsheet where is a table filled with formulas returning "" by default and I need macro which will give me a last used cell/column containing any value ignoring cells containing ""

now I use this:

mycell = Cells(3, .Cells(myCell.Row, .Columns.Count).End(xlToLeft).Column)

that returns just end of the table - last column, because all cells are containing "". I need to return number of column containing visible data. Is there any solution?

Thanks

 

[Fluff]

With that UDF in I4 what would MyCell be?

 

[vaclavvesely]

Sorry, now it works, I have found a mistake in my formula, so thanks for your help

But I have another problem, it recounts wery long time after input into cell, is there any way how to speedup recalculation of the worksheet?

 

[Fluff]

Glad you sorted it & thanks for the feedback.

As you're new question is totally different, you will need to start a new thread.
Thanks