Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-08-2014, 12:43 AM
macropod's Avatar
macropod macropod is offline Split function not working as I expect??!! Windows 7 32bit Split function not working as I expect??!! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I don't know where you're getting your information from. According to the Word VBA help file:

Split Function

Description


Returns a zero-based, one-dimensional array containing a specified number of substrings.

Syntax Split(expression[, delimiter[, limit[, compare]]])

The Split function syntax has these named arguments:
Part Description
expression Required. String expression containing substrings and delimiters. If expression is a zero-length string(""), Split returns an empty array, that is, an array with no elements and no data.

delimiter Optional. String character used to identify substring limits. If omitted, the space character (" ") is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire expression string is returned.
limit Optional. Number of substrings to be returned; –1 indicates that all substrings are returned.

compare Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values.

Settings
The compare argument can have the following values:
Constant Value Description
vbUseCompareOption –1 Performs a comparison using the setting of the Option Compare statement.
vbBinaryCompare 0 Performs a binary comparison.
vbTextCompare 1 Performs a textual comparison.
vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database.

If you care to look at some of the numerous VBA posts I've made here, you'll see plenty of implementations.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 04-08-2014, 12:52 AM
XmisterIS XmisterIS is offline Split function not working as I expect??!! Windows 7 64bit Split function not working as I expect??!! Office 2007
Novice
Split function not working as I expect??!!
 
Join Date: Sep 2013
Posts: 12
XmisterIS is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
I don't know where you're getting your information from.
It's what the VBA code editor is telling me. See screenshots attached!
Attached Images
File Type: png Untitled.png (11.5 KB, 19 views)
File Type: png Untitled2.png (63.5 KB, 19 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Split function not working as I expect??!! Signature function not working? prroots Outlook 6 08-17-2015 07:18 AM
Creating a graph for Future Value function (FV function) bmoody Excel 2 11-06-2013 10:52 AM
Split function not working as I expect??!! Wrap Text function not working? mhays Excel 1 11-21-2012 05:03 PM
Split function not working as I expect??!! Can't get AND function working Scaffold Excel 6 07-09-2010 01:41 AM
My weekday function aint working FraserKitchell Excel 12 05-25-2010 04:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft