Results 1 to 11 of 11

Comma to Trigger new row content

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    136

    Comma to Trigger new row content

    I run this macro script. With the new software I will be using to upload this I need some how if there is a replacement with a comma...I need just 173 to go in a row under 177 with no more comma... is this possible with macro?

    "Cells.Replace _
            What:=""AQUATICS - FILTERS: SUMPS"", Replacement:=""177,173"", _
        LookAt:=xlWhole, MatchCase:=True"
    "Cells.Replace _
            What:=""AQUATICS - BULBS: FLOURESCENT"", Replacement:="""", _
        LookAt:=xlWhole, MatchCase:=True"
    "Cells.Replace _
            What:=""AQUATICS - FISH BOWLS"", Replacement:=""183"", _
        LookAt:=xlWhole, MatchCase:=True"
    Last edited by Cutter; 07-30-2012 at 09:21 AM. Reason: Corrected title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1