Hey,

I have tried setting my variable to to be equal to one range dash another range, but it picks it up as minus, and since it is text, i get an error.

eg

x= Sheets("Page 1").Range("C8").Value-Sheets("Page 3").Range("E8").Value

I want it to look like this eg,

BlueWater Investment-Aggressive variant strategy

thanks,