Cut and paste - command in VBA

[Jan]

Hi
I'm looking for a command in VBA that will cut the active cel and
paste it in the same row but 2 colums to the right.
Can anyone help ?
thanks.

 

[Frank Kabel]

Hi
one way without copy and paste:
activecell.offset(0,2).value = activecell.value

 

[Don Guillett]

Since the keyword here is CUT, try
activecell.cut activecell.offset(,2)

 

[Dave Hawley]

Hi Jan

Here's another similar way
ActiveCell.Cut ActiveCell(1, 3)


***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Jan]

Thanks !! It works