Thread: Column number of last column that returns value ignore formulas
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
  
Posts: 852
Default Column number of last column that returns value ignore formulas

If Len(.Cells(3, i).Value) 0 Then



or try it with

Lcol = 23 - WorksheetFunction.CountBlank(Range("A3:W3"))





Regards

Claus B.


Thanks, Claus.

Will give it a go.

Howard
Reply With QuoteReply With Quote