Select, copy and paste - VBA code
Posted by Matthew Mills on October 19, 2000 3:56 AM
I have created a formula in first Row of Column 3 which has concatenated the two text item in Columns 1 and 2. Columns 1 and 2 have an equal but unknown number of rows in them and I want to copy the formula from the first row of Column 3 and paste it ito the rest of Column 3.
ie
C1 C2 C3
Matthew Mills R1C1&" "&R1C2
Liz Mastin Copy and paste the above
Melanie Kemp Copy and paste the above
I can do thi row by row but the spreadsheet is 22,000 rows long and this takes ages. There MUST be a way of doing thgis more efficiently.
Any ideas ?
Thanks
Matthew