LinkBack URL
About LinkBacks
When I use this macro in my table an error appear.
SEE ATTACHMENT BELOW:
Please Login or Register to view this content.
12345.JPG
When I use this macro in my table an error appear.
SEE ATTACHMENT BELOW:Please Login or Register to view this content.
12345.JPG
Your file could have got corrupted. Try creating your file again with the codes and formats again and check.
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]
What do you mean creating file again? COPY or RENAME my FILE again?Originally Posted by arlu1201
No, create it from scratch. Open a blank file and copy parts from the corrupted file into this file, code, formats, tables, formulae, everything.
Ok, I will try to copy sheet/paste data/import module and etc. to a new file.
After I create a copy of my sheet to my new file, I've seen this in my Name Manager and I can't delete it.
Some of it duplicate and cannot delete but some of them can edit and modify.
See attachment below:
123456.JPG
Looks like the named ranges are still referring to the other workbook which you have. Is it affecting your macro? If not, then maybe once your file is working, you can delete the corrupted one and clear these duplicate named ranges.
I haven't finish yet copying all of the sheet. But I've seen a lots of duplicated named range in my Name Manager. My other macro works fine. But I am being scared error happen again after I finish copying files when I don't get rid that earlier.
My question is do duplicated named ranges that I cannot delete nor edit. Ok for a while???
Example of the scenario:
In my named range:
clear1- CANNOT be edit/delete - referring to previous copied workbook
clear1- CAN be edit/delete - referring to my new workbook
clear1- CANNOT be edit/delete - referring to previous copied workbook
NOTE: I edit and correct the reference of the [1] clear1 but still the [2] clear1 still there (Still I can't delete nor edit).
Last edited by mcmunoz; 10-16-2013 at 09:18 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks