My code is giving me an error on the line containing: cell.EntireRow.Delete Shift:=xlup
The error states: "Delete method of Range class failed."
Also, the cell.address = A128 so it is selecting the correct cell I want it to.
Do I need to have the code select the row, and then delete it?
Please Login or Register to view this content.
May this can help you,
Run the code and select the range that you wanted to delete.......done
Please Login or Register to view this content.
I'm already using a userform for this particular code, so I'm just looking to see if the syntax of my command is incorrect (without changing the input method of the code)
linenumber is the variable containing the bus line number that is desired to be removed from the worksheet (I work for a transit company)
Is the sheet protected?
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Worked fine for me. What is rngtest set to?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
No, it is not.
Please Login or Register to view this content.
Ah, here's what happens. The macro runs perfectly the first time, but when I rerun it, that error occurs.
Nevermind, solved it myself. The code converted a range to a table and did not convert it back to a normal range at the end of the code. Thus, when I try to delete or add rows the second time around, Excel doesn't allow it to run properly. Thanks for the help, though!
If you have say 6 cells with the linenumber value in consecutive rows does the code delete them all?
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks