chungtinhlak
12-09-2008, 07:26 PM
I have to questions:
1. I set another workbook to open and modified it a little bit then transfer the date to another workbook and close the one i started with. But when it close, the mssage box asking me to save appear, I don't want to save, so the answer is always no. After that, another message box appear telling me that copied data is too big for the clip board. how do it just ignore these ? I use application.displayaleart = false but it doens't work and it will give me a run time error.
Application.displayalert = false
2. I have a thousands of rows, after i run my macro, on column R, if it says yes, that's the data that I want. Is there a way I can delete all rows that doesn't contain yes on column R?
thanks
1. I set another workbook to open and modified it a little bit then transfer the date to another workbook and close the one i started with. But when it close, the mssage box asking me to save appear, I don't want to save, so the answer is always no. After that, another message box appear telling me that copied data is too big for the clip board. how do it just ignore these ? I use application.displayaleart = false but it doens't work and it will give me a run time error.
Application.displayalert = false
2. I have a thousands of rows, after i run my macro, on column R, if it says yes, that's the data that I want. Is there a way I can delete all rows that doesn't contain yes on column R?
thanks