Claus Busch wrote:
Hi Terry,
Am Fri, 10 Mar 2017 15:54:54 +0000 schrieb Terry Pinnell:
But, as you see here, I finally need to get all the size 12 text to size
10. Some columns (M onwards) have inherited the source size, 12.
https://dl.dropboxusercontent.com/u/...lausValues.jpg
change the code at the end to:
Next
.Range("K2").Formula = "=J3*24"
.Rows(2).Font.Size = 10
Regards
Claus B.
I'm there, thank you so much Claus!
I've been 90% in 'copy/paste mode' and 10% in 'learning mode', so I've
greatly appreciated your patience in stepping me through all that.
Now to spend a few hours/days/weeks *understanding* all the code
contributed by you and Garry ;-)
Can't promise I won't be back for more!
Best wishes,
Terry, East Grinstead, UK