Macro that pastes plain text

[Oranjin]

Hello,

I'm having an issue. I would like to create 2 macro shortcuts that paste PLAIN text. I want this text to be predefined as follows.

B

C

D

E

F

G

H

I

J

K

L

M

2

Department

Teams

660 Floor

660 Quad

Samaccountname

Seat Type

First Name

Last Name

Display Name

Station Location

Workstation Power Ports

3

Customer

Gei

2

NE

Steve.Phil

Steward

Steve

Phil

Steve Phil

4034

West 68

4

Open

3

SW

Open Slot

Open Slot

4034

West 69

<tbody>
</tbody>

I want to write a macro so when I select cell B 3, it will drop the green contents in (demonstrated in row 4) on top of row 3. However, I want the parts in red to remain the same.

I can't get this working on my own.

 

[HackSlash]

I think you are asking for pastespecial text? Is that correct?

.PasteSpecial Format:="Text"

NOTE:
You can use the macro recorder to record your actions and replay them