Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ExcelSheet.Find
#1
Hi there!

I'm using Quick Macros and I'm learning to love it. I'm new and I've been learning from Quick Macros Help and online forums. It's been great.
Listen I just need help because I can't find this anywhere.
I need to use that function on topic but to find me something from a variable. I can make it find me something that I type in like:

es1.Find("hello" a))
out a[0].Value
out a[0].Column
out a[0].Row

But instead of hello, I want it to find something from a string variable. I cannot for the life of me make it work.

Can sombody help?

Thank you so much for your time
#2
i haven't used that function but seems all you need to do is is this
str mystring="whatever i want to search for";;change this variable to search for whatever u need
es1.Find(mystring a))
out a[0].Value
out a[0].Column
out a[0].Row
#3
That was it! Thank you!
I was trying something like:

Find("%s",mystring a)

and of course I was getting an error.
Thanks again.


Forum Jump:


Users browsing this thread: 1 Guest(s)