Hi, I am fairly new to excel and I'm writing a macro that uses the Find Function. The "searchstr" is a varaibale that is both number and letters
For example:
DIM searchstr as String
searchstr = "x234va"
ActiveCell.FormulaR1C1 = "=FIND(" & searchstr & ",W2)"
When the variable is both letter and number, the code prints
=Find( 'x234va' ,W2)
the extra ' ' causes the Find function to not work correctly. Is there a way to avoid this?
Hi Bucket, be sure to edit the post above, click the GO ADVANCED button, highlight the code in your post, then click the # icon to wrap it in code tags.
Like so:
R2C23 is the R1C1 representation of W2.
ActiveCell.FormulaR1C1 = "=FIND(""" & searchstr & """,R2C23)"
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
bucket7200 
Register To Reply
Bookmarks