I am using the INDIRECT function to call a vlookup. But it then returns the value of the vlookup and tries to evaluate that (the value is 11 if you happen to care), and this causes an error because INDIRECT cant evaluate 11
my code:
Please Login or Register to view this content.
So what do you want the result to be?
What are you wanting to use INDIRECT for. Unless I'm being unusually slow, it doesn't seem to be playing any role at all.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
@Gak67 Well i need it to return 11, but it returns an error instead because it gives 11 to the INDIRECT function
@Glenn It is just a matter of optimizing a work procedure, I need to change the name of alot of sheets called by vlookup each month. It would be faster if i could use an INDIRECT call which has as one of more inputs the new sheet name. (ofcourse i could use search and replace, but in this case it would be very laborious to do)
Thanks for the fast answers guys!
I think you need something likeFormula:
Please Login or Register to view this content.
INDIRECT() is used to convert text into something that excel can use in a formula. The way you have that syntax, it looks like you dont even need it. If you are trying to insert a sheet name into the formula, then maybe what gak suggested?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks