Thread: Column number of last column that returns value ignore formulas
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Column number of last column that returns value ignore formulas
Hi again,

Am Wed, 28 May 2014 07:50:26 +0200 schrieb Claus Busch:

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

change the line above to:
If Len(.Cells(3, i).Value) 0 Then


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote