Copy and paste formula till the last row

[vijanand1279]

Hi,

I am looking for a macro to copy and paste the formula till the last row.
I am trying to concatenate column and A and B and the formula entered in column C should get copied and pasted till the last row in column B.

Regards,
Vijay

[arthurbr]

Select the cell in col C containing formula and double click the handle at the lower right corner of this selection

[vijanand1279]

But when I try to record macro the range will be the same and does not get changed. If I have more or less rows for the next time the formula will paste till the row which was recorded earlier.

[royUK]

Why do you need a macro? Excel will do this automatically if you convert your data to a List

[vijanand1279]

I need a macro because to automate the concatenate formula and get result in col C through macro till the last available row.

[alecponting]

Hello this formula is very good copy and paste..easy and best....

[vijanand1279]

Cant we do this other than manual drag and drop for the formula till the last row?

[royUK]

If it is a repetitive task required on entering data then the List option is simplest. If it's a one off then Arthurbr's suggestion is quick & easy

[Cutter]

Duplicate post:

http://www.excelforum.com/excel-gene...kup-macro.html

[royUK]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.