Thread: Replace with total
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
  
Posts: 860
Default Replace with total
Jake Marx wrote:
This line of code works for me:

Worksheets("Sheet1").Columns(1).Replace "* ", "Total "

My fault - as Myrna and Norman pointed out, you should preface the * with a
~:

Worksheets("Sheet1").Columns(1).Replace "~* ", "Total "

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Reply With QuoteReply With Quote