automate column length

Giganews Newsgroups
Subject: automate column length
Posted by:  wsk
Date: Fri, 12 May 2006

I have a sheet with imported data and the length of the columns can change.
4 of 10 columns have formulas in them.  How could I automate adding or
subtracting the length of the column and preserve the formulas?

Also how would I automate the print screen based on the length of the
changing columns?
Excel 2000