Re: office2003 slower??
I now know what you mean when you say functions should be used to return a value(s). I guess I was just using the functions return value, more of an error check, to verify the function was completed. I have since changed that function to a sub procedure...and that actually sped up the filtering process by a little!!
As far as the upgrade of office2003, I am not sure how our IT dept. did it, I was prompted to accecpt the upgrade and re-boot. I have contacted our IT dept. and inquired to see if anyone was having similiar problems, and they have not heard of any yet......I'm thinking maybe it is internal to excel, maybe they have a differnet algorigthm for deleting/renumbering rows/cols.....not sure???
I'm not sure what part of the code you cannot see...but let me know, and I will post it.
p.s. thanks for the data type tip... int -> long
Thanks again for your help!!!