Help: Formula put into entire row creates large file size

B

bill.liu

Hi,

I have a spreadsheet where I would like one column to be the
concatenation of two other columns.

For example, in column C I would have =A1&B1.

This excel file will be given to people and they will fill in values
into columns A and B. The trick is, I don't know how many rows there
will be, so I don't know how many rows in column C should have this
formula.

If I paste this formula into the entire column C, the excel file blows
up to 3 megabytes. (It's only 15KB without this column).

Are there ways for me to accomplish this more efficiently?

Thanks for any help
 
D

Dave Peterson

Are you doing this via a macro?

If yes:

dim LastRow as long
with worksheets("Sheet1")
lastrow = .cells(.rows.count,"A").end(xlup).row
.range("C1:C" & lastrow).formula = "=a1&b1"
end with

I used the last used cell in column A to find the last row. You may want to
change that to a column you know always has information in it if the row is
used.
 
Top