I get this error
"1004 Application defined or object defined error"
and its because this below is not proper.
How do I write it properly to inject the formula to those cells? Thanks.
Original formula is
=IFERROR(INDIRECT("'"&I16&"'!"&CHAR(64+COLUMN())&"24"),"")
Please Login or Register to view this content.
Last edited by Destroy; 06-26-2015 at 03:55 PM.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Untested, but you could try:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Originally Posted by TMS
Thank you very much, this does work a charm.
I've tried to apply this to my last formula but am failing miserably. I simply do not understand why and where parts are double quoted.
My last formula I need to inject is this.
=IFERROR(MID(INDIRECT("'"&$I$16&"'!"&CHAR(64+COLUMN())&"24"),6,(LEN(INDIRECT("'"&$I$16&"'!"&CHAR(64+COLUMN())&"24"))-10)),"")
This is the best I can come up with that I think is proper but it gives the same error as OP.
Any help would be appreciated.Please Login or Register to view this content.
At face value, it looks ok but I can't really test it.
Basic principle: first check the formula is correct in the cell(s) where it will go. Then, wherever there is a double quote, put two double quotes. Simple as that.
Regards, TMS
So easy to miss, was very close but missing a parenthesis. This now works.
Please Login or Register to view this content.
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks