View Single Post
  #36   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Activate a workbook?

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.
--
Windows10
Office 2016