Skip blank columns with LOOKUP formula
Hi HuskerBroco,- yeahh that 1 is hard to fix, I tryed fix a formula without
luck
so u have to use this instead for a while if u like
put code in a ordinary module and find first not emty cell in row 3 after
column-B
Type in a cell : =kol("Schedules!b3")
Function Kol(rk As String)
Application.Volatile
Kol = Range(rk).End(xlToRight).Column
End Function
I think it wil help u som of the way
best regards PM.
|