How do you do cut/paste in macro or VB?

[ExMainframer]

I want to do a CUT and PASTE operation behind the scenes instead of relying on an unsophisticated user. I have not seen how to do this with a formula, so am wondering of other options.

Here's what I want to do:

If B2 is not blank, I want to move the contents of cell A2 into B2.

Thanks,

Pete

[Leith Ross]

Hello Pete,

The Formula below will automatically copy cell A2 into B2 if A2 is not blank, otherwise B2 is left blank.

Place this Formula in B2:

=IF(ISBLANK(A2) = False, A2, "")

Hope this helps,
Leith Ross

[ExMainframer]

Let's say that I am in cell X16 (hidden). I want to look at the contents of cell B2 to see if the cell contains anything. If B2 is not empty (contains something) I want to move the contents of cell C1 into cell B2.