Cut and paste - command in VBA

  • Thread starter Thread starter Jan
  • Start date Start date
J

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.
 
Hi
one way without copy and paste:
activecell.offset(0,2).value = activecell.value
 
Since the keyword here is CUT, try
activecell.cut activecell.offset(,2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Commands for cursor moving right, left, up, down. 4
Cut last row and paste elsewhere 1
Excel Unable to insert cut rows into Excel online anymore? 0
Cut & Paste in Excel without erasing cell borders? 1
Moving a bunch of data 1
Cut and paste macro 1
Copy from windows clipboard in VBA 3
vba powerpoint pasting named shape in selected named slides 0

Back
Top