Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Using FIND function-VBA in Excel
Name: exist69 Date: March 17, 2009 at 04:08:51 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
Hi,
I am using Office 2007.
I am trying to use the FIND function in VBA, Excel, to find a numeric value and return its row number.
The value surely exists and when I use the FIND button in the sheet the same numeric value is found, however only when I use the FIND function in VBA to find the numeric value in the same sheet run-time error '91' is returned.
Name: DerbyDad03 Date: March 17, 2009 at 07:42:32 Pacific
Reply:
It would help us solve your issue if you posted the snippet of code that produces the error. Since we know that the Find function is available in VBA and therefore should find your data, we can't tell you why you're getting an error unless you tell us what you are doing.
That said, have you looked up the Find function in VBA help?
I use Find quite often and many times I just copy the example from the Help file and then modify it to suit my needs.
0
Response Number 2
Name: exist69 Date: March 19, 2009 at 21:35:19 Pacific
Reply:
Thank you for your help.
I just solved the problem.
It was a difference in the formatting of the Find What: value, and the range which the Find Function referred to.
Summary: i created a form using vba in excel, what i want to do is if the cell that is clicked on is blank i would like excel to open the form...please help ...
Summary: Please forgive me if this has already been answered, but I didn't find what I'm looking for. I'm trying to figure out why in excel 2007 when I record a macro that does simple things such as delete row...
Summary: Hello, I have column of numbers. I would like to replace each number according to its value. So for example my column of numbers is: 2,4,7,12,90,23,12,45,23,94,21 I want to replace according to those ...
0 
