Selection.Cut Selection.Offset(1, 0) HOW to understand this code

[CAPTGNVR]

Dear All

I have a block marked. This below code drags the block down by one row
without inserting a row, so that I can enter new data. So far so good. What
I need to know is to understand the below code. I cud not find anything to
read on the below code.

Selection.Cut Selection.Offset(1, 0)

So can anyone explain this code line performance??

wrgds/captgnvr

 

[OssieMac]

If you were do this in the interactive mode you would have one or more cells
selected. The Cut is the same as Cut in the interactive mode.

Offset(1,0) means down one row and zero rows across. Therefore the code cuts
the selected data and pastes it one row down.

 

[CAPTGNVR]

D/OSSIE

My main doubt is how this expression is pasting without pasting code

And where to find this sort of syntax selection.cut with a space
slection.offset

i looked around in help on 'selection', 'cut' and didt find anything.

brgds/captgnvr

 

[OssieMac]

Can't really help you further. I don't know the reason behind it.

The more you use Excel and these forums, the more things you will find for
which you cannot find documentation.

I have some 48 pages of little examples and explanations in a Word document.
While not all undocumented, some of the official documentation leaves
something to be desired.

 

[Per Jessen]

Can't really help you further. I don't know the reason behind it.

The more you use Excel and these forums, the more things you will find for
which you cannot find documentation.

I have some 48 pages of little examples and explanations in a Word document.
While not all undocumented, some of the official documentation leaves
something to be desired.

--
Regards,

OssieMac








- Vis tekst i anførselstegn -

Hi

This is copied from the XL 2000 help file.

Cut Method

Cuts the object to the Clipboard or pastes it into a specified
destination.

Syntax
expression.Cut(Destination)

expression Required. An expression that returns an object in the
Applies To list.

Destination Optional Variant. Used only with Range objects. The
range where the object should be pasted. If this argument is omitted,
the object is cut to the Clipboard.

Regards,
Per