Results 1 to 2 of 2

Thread: VBA Using MID Function To Replace Portion Of A String

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-30-2013, 08:22 PM #2
    snb
    snb is offline
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    In this case not the function Mid has been used but the statement Mid; homonyms for different things.
    See the help files of the VBEditor.
    NB. The Statement Mid does not apply to a string, but only to string variable.
    Last edited by snb; 05-31-2013 at 03:15 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. UDF (user defined function) replacement for Excel's DATEDIF function
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 21
    Last Post: 03-07-2015, 09:47 PM
  2. Replace Pivot Table Source Range with New Address VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 04-25-2013, 07:51 PM
  3. FindAll Function In VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 02-19-2012, 04:11 PM
  4. IIF Function in VBA
    By Nishant Choudhary in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 12-01-2011, 08:51 PM
  5. Replace Currency Format From One to Another at One go !! (VBA)
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 07-19-2011, 09:13 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