Need some help from the VBA gurus please. I'm working on a project (simplified here) in which I need to remove the text in cell F2:J2 (merged). The data within that cell will then be placed into cell A3:J3 (merged). However I do not need the entire text/date string-- only "Report Date: dd - mmm - yyyy". I'm looking either for a VBA solution to cut and paste which will isolate that text string (variable date) or a formula to CONCATENATE "Report Date:" with Today(). When I tried to write an ActiveCell.FormulaR1C1= i received an error for expected end. Would really appreciate any help.
Thanks