Thread: Unable to set ColumnWidth property
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DaveL DaveL is offline
external usenet poster
  
Posts: 22
Default Unable to set ColumnWidth property
The VBA code I'm having trouble with follows:
Set Day_CalColHdr = Range(Data.Cells(1, ColC + 1), Data.Cells(4, ColC2))
Day_CalColHdr.ColumnWidth = 2.5
The commands work fine with custom view zoom set at 85% but when I set it to
25% so I cans see it executing I get a 1004 run time error and the following
error:"Unable to set the ColumnWidth property of the range class." Why does
this happen?

Reply With QuoteReply With Quote