codetoad.com
  ASP Shopping CartForum & BBS
  - all for $20 from CodeToad Plus!
  
  Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM 
Search Site:
Search Forums:
  autofit in excel  smith33 at 03:50 on Friday, May 20, 2005
 

I was wondering if anyone can tell me why this code won't work or if there is a better way to autofit column "A" using code for VBA in excel.
Thanks


Set rngCurrent = shtSales.Range("A:A").EntireColumn.AutoFit
Set rngCurrent = rngCurrent.Offset(rowoffset:=1, columnoffset:=4) _
.Resize(rowsize:=rngCurrent.Rows.Count - 1, columnsize:=1)








CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums
//








Recent Forum Threads
•  Job @ EarlySail
•  Job @ EarlySail (perl)
•  Security - Code verify
•  IPC problem
•  Re: import contacts of msn/yahoo
•  Cookies and Threads C++
•  right justify a background in a table?
•  Help with Loop (C++/MFC)
•  Help with Loop (C++/MFC)


Recent Articles
ASP GetTempName
Decode and Encode UTF-8
ASP GetFile
ASP FolderExists
ASP FileExists
ASP OpenTextFile
ASP FilesystemObject
ASP CreateFolder
ASP CreateTextFile
Javascript Get Selected Text


© Copyright codetoad.com 2001-2007