Wolfgang
06-06-2006, 09:20 AM
Good evening all...
I have a range in column D which starts at D4 and ends at D100.
Data will be added in the course of time without any empty cells between.
Now, I like to be able to select some of them clear their contents and do a delete with ".Delete Shift:=xlUp" which works fine.
BUT - I need to keep that range intact, meaning the amount of cells that I delete and move up, need to be inserted below so that my range remains the same.
Does that make any sense?!
Thank you and have a nice day/evening...
Best,
Wolfgang
I have a range in column D which starts at D4 and ends at D100.
Data will be added in the course of time without any empty cells between.
Now, I like to be able to select some of them clear their contents and do a delete with ".Delete Shift:=xlUp" which works fine.
BUT - I need to keep that range intact, meaning the amount of cells that I delete and move up, need to be inserted below so that my range remains the same.
Does that make any sense?!
Thank you and have a nice day/evening...
Best,
Wolfgang