All,
I keep getting the application/object defined error at this piece of my code.
The larger code is below.
Please Login or Register to view this content.
X is just a counter and it works fine until its time to delete, in which case the error is thrown... Any ideas where I went wrong?Please Login or Register to view this content.
I don't seem to get an error when I run this on data that I made up.....
can you upload some data with confidential stuff removed?....
Have you stepped through the code to look at the variables and possibly see what is causing the issue?...
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
In this,
... the two Cells references are to the active worksheet, which will fail if it's not DataPages.Please Login or Register to view this content.
You could use
The dot before Range isn't necessary unless the first cell reference is a literal string, but it doesn't hurt.Please Login or Register to view this content.
But my preference would be
Please Login or Register to view this content.
Last edited by shg; 06-03-2015 at 06:15 PM.
Entia non sunt multiplicanda sine necessitate
Thanks all for the replies. shg, your last preferred code, how does it not delete row 1 in "s:y"? I see you made the row X which is what I want but I don't understand how "s1:y1" works...
In row 5, range("S1:Y1") is S5:Y5.
Ok great, I will try this code when I get back to the computer in a few and post back, thanks again.
Thanks again shg, this worked great!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks