Thread: Redefining Styles
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Grant Reid Grant Reid is offline
external usenet poster
  
Posts: 51
Default Redefining Styles
Hi All

Managed to sort this out myself.

Sub Change_Style
ActiveWorkbook.Styles.Add Name:="_HD1", BasedOn:=ActiveCell
End Sub

Many Thanks - Grant


Reply With QuoteReply With Quote