View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Bracken Phil Bracken is offline
external usenet poster
 
Posts: 2
Default Macro to set column widths in a worksheet

Hi,
I've tried to create a macro that will go in and set the column widths
(columns A thru M) to specific widths. Each column is a different
width. I used the record button and set them as I wanted and then
stopped the recording. When I went to another worksheet in the same
workbook and executed I could see it change the width for a split
second and then they each went to a standard 7.71 width. No error
messages. No explanations.

My goal is a macro to be able to import or copy a page from 5
different worksheets that I receive twice a month and be able to view,
print and extract data from them for other reports.

Thanks in advance,
Phil