allsourav
08-01-2018, 02:14 AM
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
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