Hi Guys,
I have a code which gives me an error. Its a lengthy code and gives me an error "delete method of range class failed - run time error 1004". Can someone give me an easy alternative to the lengthy code. Thanks in advance.
Code->
Cheers
Please Login or Register to view this content.
plasma33
Hi plasma33,
The error message is due to the fact that the "Table" tab is protected and therefore you cannot delete any row(s) from it.
Once you've unprotected you can either use you code, or you can try this (initially on a copy of the tab as the results cannot be undone if they're not as expected):
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
perfect that worked like i wanted.....i am gonna mark the thread as solved....thanks again for helping
Cheers
plasma33
Thanks for letting us know and you're welcome. Thanks also for adding a point to my reputation
You are welcome dude....actually its not working now...it was working fine before....but its giving me the same error again.......its giving me that error at->
Waiting for your reply...Thanks in advance...Please Login or Register to view this content.
Cheers
plasma33
Hi again,
Is there an alternative to the above code like a more simpler or a different one??? Coz I tried most of the solutions that said on the internet for that particular error but still not working.....
Cheers
plasma33
That's odd it's failing there
Are you sure the "Table" tab isn't protected?
yeh i am sure the table tab isn't protected....at first i did manually from going to Home-> Format Cells -> Protection and Unchecking the Locked....but when I tried running the macro it changes back to protected...donno why its doing it....but then I made a macro for unchecking/unprotecting the tab....here is the code for it->
CheersPlease Login or Register to view this content.
plasma33
That just unlocks cell P15 - it doesn't unprotect the tab if it is protected
I'd say the tab is protected which is causing the error. To check, click on the Review ribbon and if the first option in the Changes tab says Unprotect Sheet, the tab is protected.
Not sure, but as you can write to the tab see if replacing this line of my code...
...with this helps:Please Login or Register to view this content.
RobertPlease Login or Register to view this content.
Last edited by Trebor76; 06-28-2012 at 02:12 AM.
Working fine now...i just changed to a new worksheet and deleted the old worksheet....and its working algud so far....thanks for all your help mate...will wait and c how it goes and will try your solution too....
Cheers
plasma33
Glad to hear it's all sorted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks