View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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.