Help: Formula put into entire row creates large file size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bill.liu@gmail.com - 27 Jul 2006 01:06 GMT

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

Reply to this Message

Dave Peterson - 27 Jul 2006 01:19 GMT

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.

> Hi,
>
[quoted text clipped - 14 lines]
>
> Thanks for any help

Signature

Dave Peterson

Reply to this Message

Rate this thread: