I am starting to find more uses for Arrays. Currently I add a few cell contents to the heading of worksheet like this:
[VBA].LeftHeader = "&""Arial,Bold""&12" & Range("A5").Value & Range("B5").Value _
& Range("C5").Value & Range("D5").Value & Range("E5").Value[/VBA]
However, I want to try to change it into an array. This is what I tried:
[VBA].LeftHeader = "&""Arial,Bold""&12" & Array(Range("A5:E5").Value)[/VBA]
However, this is giving me an error.