Not able to use Find command in vba,Please help

[Sourav Bhattacharya]

I have string s which contains subham$

Now using excel's built in command find i lie to know the position of the dollar symbol,there might be other ways but i like to use find in vba code and use a variable inside it

Dim s As String
s = "subham$"
Sheets("Sheet1").Select
Range("A1").Select
ActiveCell.FormulaR1C1 = "=FIND(""$""," & s & ")"

I am getting the error Application defined or object defined error,what am I doing wrong please help

Thanks in Advance
Sourav Bhattacharya

 

[NARAYANK991]

Hi ,

Try this :

Public Sub temp()
          Dim s As String
          s = "subham$"
          Sheets("Sheet1").Select
          [A1] = "=FIND(""$""," & """" & s & """" & ")"
End Sub

Narayan

 

[vletm]

Sourav Bhattacharya
1) use CODE-tags as written in Tip

2) I would do that like

Sub xxx()
    s = "subham$"
    Sheets("Sheet1").Range("A1") = WorksheetFunction.Find("$", s, 1)
End Sub

 

[Sourav Bhattacharya]

Solved,Thank you so very Much

Sourav Bhattacharya

 

[bobhc]

If you had taken just a moment to read the forum rules you would have read this bit,

• Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out.
• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
• Please don't attach or post links to copyright material including Books, Videos etc. Your post will be deleted

Members are giving their time for free to help you unaware that members of other forums may have given you an answer.