Macro that pastes plain text

Oranjin

Board Regular
Joined
Mar 16, 2016
Messages
81
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.

BCDEFGHIJKLM
2DepartmentTeams660 Floor660 QuadSamaccountnameSeat TypeFirst NameLast NameDisplay Name
Station LocationWorkstation Power Ports
3CustomerGei2NESteve.PhilStewardStevePhilSteve Phil4034West 68
4Open3SWOpen Slot

Open Slot4034West 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. :(
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

HackSlash

Active Member
Joined
Nov 18, 2016
Messages
360
I think you are asking for pastespecial text? Is that correct?

Code:
.PasteSpecial Format:="Text"

NOTE:
You can use the macro recorder to record your actions and replay them
 
Last edited:
Upvote 0

Forum statistics

Threads
1,191,687
Messages
5,988,013
Members
440,125
Latest member
vincentchu2369

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top