View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Change column width

Hi Robert,

Am Sat, 4 Apr 2015 02:36:09 -0700 schrieb Robert Crandal:

Is it possible to reference each column with a numerical
index? Rather than using "A:A"?


try:

Columns(1).ColumnWidth = 1.57


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional