LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Find Character Position in String


Hi there,

I am writing some code in Excel VBA, and I need to find the position of
a colon in a string variable. I thought I would be able to use the
'find' function to return the position value as I would on a normal
worksheet. However, VBA doesn't seem to recognise the function ("Sub or
Function not Defined"). I have also checked the help files and there
seems to be no mention of it. Could somebody please advise me on an
alternative.

Many thanks,

Dave


--
SportsDave
------------------------------------------------------------------------
SportsDave's Profile: http://www.excelforum.com/member.php...o&userid=34641
View this thread: http://www.excelforum.com/showthread...hreadid=544078

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
return a character at a certain position in a string of text Miranda Excel Worksheet Functions 3 May 8th 23 11:46 AM
Find position of first non-matching character Greg Lovern Excel Worksheet Functions 18 June 1st 08 01:52 AM
Function to return Character Position of Xth character within a string Andibevan[_2_] Excel Programming 4 June 9th 05 03:24 PM
function for finding position of numeric character in a string Paul Excel Programming 5 February 6th 05 12:19 AM
How find character position # in string from right end? Or how get range row num Ian Elliott[_3_] Excel Programming 1 December 17th 03 03:56 PM


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"