Thread: Application-defined or object-defined error (worksheet, range, sel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kaak[_97_] Kaak[_97_] is offline
external usenet poster
  
Posts: 1
Default Application-defined or object-defined error (worksheet, range, sel

I think I need the whole code
but why do you select, why don't you:

With Worksheets("DIFF").Columns(CommonColInd, NegCol)
Interior.ColorIndex = xlNone
ClearContents
End With


--
Kaak
------------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513
View this thread: http://www.excelforum.com/showthread...hreadid=567361

Reply With QuoteReply With Quote