Macro to combine cells

[flexfanatic]

Yesterday someone was able help me "iron out" a formula to combine cells and add some text.

Now I would like to automate it with a macro (Excel 2007). For example I have.

="http://www.shoppingbuddy.net/"&A2&"~"&B2&"/"&C2&"~"&D2&".htm" which pulls text from different cells and combines it into a cell of my choice.

Now I need to apply this to all cells in the worksheet (e.g., =[URL="http://www.shoppingbuddy.net/"&A3&"~"&B3&"/"&C3&"~"&D3&".htm"]http://www.shoppingbuddy.net/"&A3&"~"&B3&"/"&C3&"~"&D3&".htm[/URL] , =[URL="http://www.shoppingbuddy.net/"&A4&"~"&B4&"/"&C4&"~"&D4&".htm"]http://www.shoppingbuddy.net/"&A4&"~"&B4&"/"&C4&"~"&D4&".htm[/URL] and so on)

It's over 50,000 rows so you may understand why I need to have a macro

 

[AlphaFrog]

• Put your formula in a cell. For this example, say it's cell E2.
• Then in the Name box, just to the left of the formula bar, type in E2:E50000 and Enter. That will select those cells.
• Then Ctrl+D on the keyboard will autofill your formula down within the selected cells.