Delete range not rows

i want to delete range that i copy and paste it in other sheet but i want to delete the range not the rows, when i write the delete sentence it run the whole code for the half of data and other not , i don't know where is the mistak in my code.

Please Login or Register  to view this content.

Instead of

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Originally Posted by stnkynts

Instead of

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

thanks for your reply but this code will delete the contents of the cells but what i want is to delete the cells itself not it's content only

I think that you should add before the end if the following line:

Please Login or Register  to view this content.

because when you delete the range, the rows will be shifted up and when that happens you lose a line that doesn't get tested,
I hope that makes sense for you
regards,
Mohammad

Can i anyone help me in MS EXCEL, convert the number to spelling (like 10000) i want to convert to TEN THOUSAND ONLY i tried with spell number formula but its not working

Thanks

with Regards

Akber

Hi,

i m an accountant i have some Problem in the PDC , as per my workheet the detail as follows,
A B C D
1 Customer Name Amount Date Status
2 XYZ 1000 25/05/2011 Due
3 ABC 2000 23/05/2011 Received
4 AAA 2000 22 /05/2011 Due


Total Collection = 5000
Total Received =2000
Total Due= 3000

i want to fix the formula in Totals columns in (Total Due and Total Received) with Vlookup,

suppose if change the status of Cheque, the automatic effect in that column

please help in this issue

With Regards
Akber

Akber,
you have already broken twice the ame rule in our forum, and also trying to get answers via visitor messages
Please read the rules before posting any further.
Any other infraction will be met by temporary banning

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Originally Posted by mohd9876

I think that you should add before the end if the following line:

Please Login or Register  to view this content.

because when you delete the range, the rows will be shifted up and when that happens you lose a line that doesn't get tested,
I hope that makes sense for you
regards,
Mohammad

of course it work in delete rows , but it also didn't copy and paste just half of the data (ex. if i have to copy 4 rows , it copy only 2 but delete all of the 4)

hope find solution , it'll make me crazy