Thread: Excel Macros
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excel Macros

Good thinnin'


Gord

On Wed, 31 Dec 2008 12:18:52 -0800, "Chris Premo" wrote:

I ended up using this and it worked:


Selection.Replace What:="~*~*", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False