Hello all,

I have a question regarding Excel 2000 (from Office Pro) and the use of
Macros. Essentially, i have a spreadsheet containing 20,000 records and i
have 3 columns that should be one - the data that was supposed to be in one
column has ended up split over 3 columns and i desperately need to fix this
but am lost as to how to go about it...?

I have created the following Macro which copies the contents of the 2nd and
3rd column into the 1st column but this only works for the first record -
would it be possible to make this automatically continue until there is no
more data to process...?

Sub Ma_Merge3Columns()
Range("N1").Select
ActiveCell.FormulaR1C1 = "Text Content"
Range("M1").Select
ActiveCell.FormulaR1C1 = "Text Content"
Range("O1").Select
ActiveCell.FormulaR1C1 = ""
Range("M1").Select
ActiveCell.FormulaR1C1 = "Text Content"
Range("M1").Select
End Sub

I would appreciate any advice on this matter...

Thanks in advance...

Regards,

Alex