Results 1 to 4 of 4

problem with replacing values formatted as "time"

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2013
    Location
    Warsaw
    MS-Off Ver
    Excel 2013
    Posts
    2

    problem with replacing values formatted as "time"

    Hi All,

    Can you please help me with one issue.
    I`m trying to use excel macro to replace some values. The problem is that the values I want to replace are "time" formatted (hh:mm:ss) and the following command fails (actually do nothing):

     Sheets("Sheet1").Select
        Cells.Replace What:="23:37:00", Replacement:="time2sleep", LookAt:=xlPart, _
            SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False
    But in opposite way it works (replacing "time2sleep" to "23:37:00")

    Thank You in advance for answers.
    Last edited by inglese; 11-07-2013 at 08:48 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 05-06-2013, 08:44 PM
  2. [SOLVED] Removing ".", "?" or "!" from last word of sentence and replacing it later in vba.
    By staggers47 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-16-2013, 07:20 AM
  3. Replacing error values "0" with "-"
    By jhooker84 in forum Excel General
    Replies: 2
    Last Post: 09-28-2011, 03:37 AM
  4. substituting or replacing cell values to "" if they = value in AM20
    By simonsmith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2009, 07:46 PM
  5. Replacing "0" values with null string in array while preserving cell formula
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2007, 01:07 PM

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