I've got the following problem:
I am trying to use a variable within a formula that should be inserted in a cell, but I get the following error:
Run-time error '1004':
Application-defined or object-defined error
Please Login or Register to view this content.
The variable "Variable" is the last row of interrest in "Sheet1"
Last edited by Freakazoid; 04-28-2011 at 08:16 AM.
Assuming your variable is an integer
Please Login or Register to view this content.
Hope this helps
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
It did not help me, I still have the same problem. The solution you posted was also my own first attempt, and the [] was something I read about on another website.
So still I would appreciate it if anybody could help me.
In the absence of your workbook, try this workbook
Run the macro "test" and check the result with the dropdown in "Dashboard" A3
Please Login or Register to view this content.
If this is not what you are trying to do, then post a sample workbook, with the data you are trying to find and your code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks