automate column length

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
First record adding your formulae with the macro recorder.

Then edit your macro using the following to return the last row of your
column

LastRow = Cells(65536,1).end(xlup).row
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable Length Columns 2
Max Length in a row 1
can you automatically size text to fill a column? 4
How to have charac in new column with 40 char length only... 2
Split column contents (de-concantenate) 7
select a range in a column 4
how to avoide duplicate entries in to cell 2
Subtotal - SUM, COUNT NUMBER, 'Live' Formula 5

Back
Top