Thread: Compile error, variable not defined
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Darrin Henshaw Darrin Henshaw is offline
external usenet poster
  
Posts: 38
Default Compile error, variable not defined
If I understand your code right, you want the entire column formatted
correct? If so, change
Set CurCol = Worksheet.Range.Column, to
Set Curcol = ActiveCell.EntireColumn

Does that help?

*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote