I have a macro for my footer that uses the RIGHT and LEN function to pull strings from various cells within the worksheet. I've tested on various sheets and this works.
ActiveSheet.PageSetup.RightFooter = Right(Range("D11"), 8) + Right(Range("D4"), Len(Range("D4")) - 24)
I did my homework and went with the 'record macro' method to format the footer and came up with the following:
ActiveSheet.PageSetup.RightFooter = "&""Times New Roman,Regular"
I do not know how to combine the two without losing my values or getting a compiling error.