+ Reply to Thread
Results 1 to 4 of 4

Trim Range with VBA

  1. 07-26-2017, 03:53 PM #1
    yuenk
    yuenk is offline
    Forum Contributor
    Join Date
    11-19-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    137

    Trim Range with VBA

    I have a code for the trim function. Instead of working in the selected cells I want this to work for column H

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 07-26-2017, 03:59 PM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Trim

    How about like this

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 07-26-2017, 04:02 PM #3
    yuenk
    yuenk is offline
    Forum Contributor
    Join Date
    11-19-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    137

    Re: Trim

    Quote Originally Posted by jeffreybrown View Post
    How about like this

    Please Login or Register  to view this content.
    Thank you!
    Reply With QuoteRegister To Reply
  4. 07-26-2017, 04:04 PM #4
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Trim Range with VBA

    You are very welcome. Happy to help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VLOOKUP + TRIM, TRIM Lookup table array...
    By mangesh.mehendale in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-19-2016, 02:10 AM
  2. VBA - Trim Range Copy/Paste
    By rafapmotta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2016, 02:15 PM
  3. Trim filename from filepath using VBA with range in specific column
    By isritter in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-20-2014, 05:42 PM
  4. [SOLVED] Trim all values within a range without looping
    By kebec_ska in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2012, 03:14 PM
  5. TRIM a range of cells with evaluate
    By rwgrietveld in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-17-2010, 07:02 AM
  6. trim range/column on particular sheet
    By JohnSeito in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2007, 01:43 PM
  7. Trying to trim a trailing space char and the Trim function isn't working
    By Psychochook in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2007, 11:28 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1