VBA to forward or backward copy and paste function

It's probably a little bit more complex than you imagine, Outlook.

At the heart of your request is the following:
* Intercept any Left and Right Arrow keys (that's what you mean by Forward and Back, right?) and translate them into movements of a multi-cell block, and then place the contents of the newly selected block into a specified area.

If that is NOT a correct interpretation of what you are asking for, please let us know, as soon as possible.

If that's the case, then there are more questions.

Even though the block may be 3 columns wide and 5 columns high, what happens if you type an Up- or Down-Arrow? There are several possibilities:

1) De-select the block, and simply move to the cell which is one up or down from the top-left hand corner (or top right, or bottom left, or bottom right)

2) Keep the block selected, and select the block that includes a cell outside your data area

3) If you move outside the special zone, and then move back, should the block automatically be selected again? Based on which cell?

As you can see - the possibilities multiply very fast.

While I wait to hear from you again, I'll see what I can put together

HTH

Tony

In a helper Column for example AA. From AA1 sequence numbers (ie 1, 2, 3, 4) on down the column. Then maybe:

Sub outlook888zz()
Dim x As Long
x = Range("AA1").Value
Range(Cells(1, x), Cells(1, x).Offset(5, 2)).Copy Range("A10")
Range("AA1").Delete xlUp
End Sub

The interpretation is correct except the VBA is not trigger by just clicking on the left and right arrow.

The forward and backward could be via CONTROL + <-- or --> or Control + 1 or 2 so up or down arrow will not affect the VBA.
Or I can use my mouse to click on two created button for the forward and backward action.

When I doing the forward and backward function, I will not be doing anything else on the spreadsheet. The sole purpose is just to copy and paste different blocks into the specific area. I will be always in the special zone of A1:Z5 and selecting different blocks to be pasted.