LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Macro edits won't work

The first 3 commands of this macro work fine. Not knowing much about VBA, to
try to add 2 more commands, I copied and pasted a working command twice and
substituted the characters I wanted to manipulate in commands 4 and 5.

Commands 4 and 5 don't work.

How can I troubleshoot this and see where is the problem so I can correct it.

Tx for your help. The macro is as follows (hopefully it is readable in this
forum)"


Sub Second_Macro_Rate_Comparisons()
'
' Change_Cellular_in_parentheses Macro
' Macro recorded 3/4/2005 by Edits
'

'
Cells.Replace What:=" (Cellular)", Replacement:="-Cellular", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
Cells.Replace What:=" GSM", Replacement:="-Cellular", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
Cells.Replace What:=" - ", Replacement:="-", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
Cells.Replace What:="(", Replacement:="-", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
Cells.Replace What:=")", Replacement:="", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
End Sub

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert "Find dialog box" edits into macro danno-c[_2_] Excel Discussion (Misc queries) 3 September 24th 09 05:40 PM
Macro to Protect the Whole Workbook and Allow Range Edits EugeniaP Excel Discussion (Misc queries) 2 September 8th 08 05:43 PM
Can I allow Additions but not Edits? Keith Excel Discussion (Misc queries) 2 November 9th 06 01:10 PM
Footer edits Sheilamom Excel Discussion (Misc queries) 1 June 5th 06 02:20 PM
Limiting edits alexandra60 Excel Discussion (Misc queries) 3 February 8th 06 09:55 AM


All times are GMT +1. The time now is 03:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"