Thread: a little help with an non critical but annoying error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default a little help with an non critical but annoying error
Try
ActiveWorkbook.Worksheets("Dashboard").Columns(5). EntireColumn.AutoFit

If this post helps click Yes
---------------
Jacob Skaria


"DawnTreader" wrote:

Hello All

ActiveWorkbook.Worksheets("Dashboard").Columns("E: E").EntireColumn.AutoFit

do i need to do the entire column? or does the E:E take care of that?

sometimes it comes up with an error saying that the range isnt available for
autofit, or something like that.

any and all help appreciated.
Reply With QuoteReply With Quote