Results 1 to 4 of 4

Thread: Replacing VbTab with Underscore in ActiveSheet

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-10-2011, 07:07 PM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi Rasm,

    This works for me.

    Code:
    activesheet.usedrange.Replace chr(9),"_",2
    Kris
    Reply With Quote Reply With Quote
  2. 04-10-2011, 07:15 PM #2
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    15
    You mean replace entire code with that one line - sweeetttt - it works - tyvm:D
    xl2007 - Windows 7
    xl hates the 255 number
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Trim Text after 3rd Underscore but retain format
    By trankim in forum Excel Help
    Replies: 4
    Last Post: 05-13-2012, 10:44 AM

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
  •  

Forum Rules