View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Copy basic format from one cell to another

Just remove them after the paste:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 6/4/2009 by James Ravenswood
'

'
Range("A1").Select
Selection.Copy
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteFormats
Selection.FormatConditions.Delete
End Sub

--
Gary''s Student - gsnu200856


"joeeng" wrote:

Is there a way to copy the basic cell format from one cell to another without
copying the conditional format with it?