Results 1 to 4 of 4

Faster code to delete character "#"

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Faster code to delete character "#"

    Hello,

    In my sample (sheet Turnover) I use the below mentioned code to delete the charahter "#" from column M (from some thousand cells), the code is working fine just too slow for me, do you have faster solutions?

    Sub test()
    Dim c As Range
    
    Application.ScreenUpdating = False
    
       For Each c In Worksheets("Turnover").Range("M9:M2294")
       With c
       If Left(.Value, 1) = "#" Then .Value = Left(.Value, Len(.Value) - 1)
       End With
       Next c
       
    Application.ScreenUpdating = True
    
    End Sub
    The sample file has been added to this thread.

    Thanks in advance your help!
    Attached Files Attached Files
    Last edited by Villalobos; 05-01-2015 at 04:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] I need faster pagesetup code
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2015, 10:16 AM
  2. [SOLVED] Get a code to run faster
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2015, 02:07 AM
  3. Can code run faster
    By leem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2010, 02:52 PM
  4. [SOLVED] I need faster code
    By mpeplow in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2007, 05:30 PM
  5. Faster way to code this
    By jhahes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2006, 12:08 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