Merge cells with data that was generated using a formula

[paulabrink78]

I have a spreadsheet - it also contains a Macro - that completes a Gantt chart with a country name and Time Zone. This is done by a very smart formula that I did not build myself but had lost of help with. I, now want to merge these cells so you can see the name of the country and UTC nicely. Doing it manually will defeat the point of trying to make this sheet as automated as possible.

I was advised that this should be done in VBA...

I would be greateful for any ideas.

 

[sxhall]

Can you add the macro here? It is a simple concatenate but as to how it will fit in to your code that is different matter.

The code below looks at the two cells in my data and combines the cell contents into a single cell keeping the time format. Not neccisarily the correct method for you. Would also need to know where you want the combined result to go.

Sub MergeStuff()

Range("C2:C7").select

For Each i In Selection

i.Offset(0, 2).Select
i.Value = i.Offset(0, -2).Value & " - " & Format(i.Offset(0, -1).Value, "hh:mm")

Next i

End Sub

 

[paulabrink78]

Thank you very much! I am going to test this.