Thanks. As you said, selection.clear is working.

We are also analyzing the issue with the following delete code. there is no
data at the bottom (or side) of the region we selected for deletion. As u
said, even if delete moves the column/row after deletion, theoretically it
shouldnot affect us.

Our code:
Range("A4","IV65000").select
selection.delete

This code is working in Excel2007 but in excel 2003 it is working for
somesheets and not for other( inconsistent behaviour).


Any idea pls?

"OssieMac" wrote:

Like I said, delete moves other columns or rows into its place. Use
Selection.Clear if you want to copy other data into its place.

Regards,

OssieMac

"Radhakrishna k.v.n.r" wrote:

Thank u all for immediate response.

The sheet is not protected.
And we are deleting all the contents in the entire region and we need to
copy new contents from other sheet.

We selected the Range and gave selection.delete. but this is not deleting
the contents which is causing problem.

But if we give selection.clearcontents, it is working.
We are little bit confused of this behaviour.

Please help us.

Thanks,
Radhakrishna

"OssieMac" wrote:

Selection.Delete should also include the direction to shift cells otherwise
Excel decides. I wonder if this is causing a problem. Options a-

Selection.Delete Shift:=xlUp

Selection.Delete Shift:=xlToLeft

Selection.EntireRow.Delete

Selection.EntireColumn.Delete



Based on your other comments re clear, I suppose you really do want to
delete which removes the rows or columns within the selection and places the
columns to the right or rows from below in their place. Selection.Clear just
removes the data out of the cells.

Regards,

OssieMac





"Radhakrishna k.v.n.r" wrote:

Hi all,
we are currently using MSExcel 2003 version. We are facing a problem of
deleting perticular data by selecting the range. We are first selecting the
specified range and we are doing the selection.delete operation using macro.
But it is selecting the range but it is not deleting. If i gave
selection.clearformats and selection.clearcontents it is deleting fine. The
selection.Delete is working fine for remaining workbooks. can any one give
your opinion about this.