I had a simple delete rows macro based on a range summing to nil that worked in testing at home and then it didn't when I really need it to work at work..
Code is:
Help please!![]()
Please Login or Register to view this content.
I had a simple delete rows macro based on a range summing to nil that worked in testing at home and then it didn't when I really need it to work at work..
Code is:
Help please!![]()
Please Login or Register to view this content.
Well... could you please post a sample of the looking of your Workbook?
I will do tomorrow morning. I was using it as a Function and calling it from another much larger routine to tidy up the end result (taking any row with "Total" in it or nil value , and it all worked fine when I was testing at home. Im sure I gave it a run a t work as well. I ramble on. I'll post sample of workbook tomorrow.
The line it is hanging on is
![]()
Please Login or Register to view this content.
I really like to use the Union feature for programs like this - try:
![]()
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi Aka
Can you explain (in layman's terms) what you are recommending here. Don't you need to give U value before you set the if statement? I have really limited time tomorrow (in the middle of month end and lost several hours today due to various issues, my delete rows macro being 5% of them!). Why do you think this will work? (I don't like black boxes, mysteries etc..!). Thanks in advance for your support.
Chris
I know this works - I use it all the time, it may be the quickest ( without using the Filter feature ) way to dump a bunch of rows.
Will set any qualified Range.![]()
Please Login or Register to view this content.
You might want to change this line in case you get a "dry run"
![]()
Please Login or Register to view this content.
Hmmm. Really frustrating. After a very long week I ran the original macro again last night and the pesky thing worked as part of a call function of the larger macro consolidating data from a sample of feed files.
If I get time I'll run some more tests next week on larger set of files to see if I can replicate error. Orin - I'll have a play with the Union code which will hopefully make more sense when I see what it does in action.
Thanks for suggestion.
If I can't replicate the issue I had Ill close the thread.
Chris
OK - Let's see![]()
Re: Unable to get SUM property of the worksheetfunction class
Don't you have Error value within a row?
If so, try something like
![]()
Please Login or Register to view this content.
Ahh, Jindon, You may be on to something. The first column of data has a lookup formula in it which, as it is currently written, could return an error value in some circumstances. I'll check it out Monday. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks