I've never seen .Text used in Excel VBA code. Does this help with understanding https://learn.microsoft.com/en-us/of...cel.Range.Text