Autofill a Column to last row of data
Posted by Maud on July 25, 2000 4:13 AM
I'm looking for a code that will do the following
I paste data from another workbook to the workbook in which want the macro to work.
The Pasted data will vary in size, so that the Row length will change - I have a formula alongside that changes the format.
What I want it to do is Autofill the formula to the last row of the pasted data.
EG copied data A2:D410
Formula in Column E
The formula in Column E will autofill down to E410
Is this possible?