infinity
09-23-2009, 04:58 PM
HELLLLP! :help
I am trying to add rows at the top of a worksheet through code and everytime, I get the error "Excel cannot complete this task with the available resources, choose less data or close other applications". I am doing this on a sheet that has no formulas or formatting only raw text data and it only had about 30 lines of data on it. I then tryed it on the same worksheet with no data on it and I still get the same error. I tried doing it without using my code and get the same thing! This is driving me insane!!! Please if anyone has a solution, I would be most appreciative. Thank you all so much. :banghead:
I am trying to add rows at the top of a worksheet through code and everytime, I get the error "Excel cannot complete this task with the available resources, choose less data or close other applications". I am doing this on a sheet that has no formulas or formatting only raw text data and it only had about 30 lines of data on it. I then tryed it on the same worksheet with no data on it and I still get the same error. I tried doing it without using my code and get the same thing! This is driving me insane!!! Please if anyone has a solution, I would be most appreciative. Thank you all so much. :banghead: