LinkBack URL
About LinkBacks
i keep getting a 1004 error with the below code- object defined error
Moderator Note:
Please Login or Register to view this content.
Pls use code tags around your code next time as per forum rules.
availability is the name of my table
i keep getting a 1004 error with the below code- object defined error
Moderator Note:Please Login or Register to view this content.
Pls use code tags around your code next time as per forum rules.
availability is the name of my table
Last edited by Fotis1991; 10-10-2013 at 08:50 AM.
Range("data!Extract") doesn't look right to me, I think you mean Sheets("data").Range("Extract")?
THE FORMULA I HAD WORKS IN ANOTHER SHEET
Please Login or Register to view this content.
Last edited by arlu1201; 10-10-2013 at 09:35 AM.
MAYBE THERE IS AN ERROR IN YOUR DATA THEN. UPLOAD A WORKBOOK.
I'm guessing the problem is that you don't have a named range on your data sheet called Extract though, looking at what you have posted.
excel_upload_table.xlsx
A subset of the sheet attached
thanks
Miller,
You missed the note from the moderator in post 1. I have put code tags for you in post 3 again. Ensure you do not break the rules again.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
That works on your example file. So I think the problem is with your names (AVAILABILITY#ALL and Extract). Do both of these exist on your data sheet? I can't really help because you didn't included the named ranges or code in your attachment.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks