Thread: Font Object
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Clift[_3_] Jack Clift[_3_] is offline
external usenet poster
 
Posts: 20
Default Font Object

How do I set the font property of a cell / range to be the same as a
reference cell, without going through all the myriad of font properties and
setting individually

I have tried all manner of variations on the theme:

dim oFont as Font

set oFont = RefRange.Font
TargetCell.Font = oFont

Does not work and all manner of mucking around has not improved results

Thanks

Jack