Copy Specific Text String To Clipboard At End Of Macro

macropod · #1 10-05-2022, 06:29 AM

What's with all the Selecting and ScrollRow? For example, all of:

Code:

Sheets("Data Today").Select
Range("B37:F64").Select
Selection.Copy

can be reduced to:

Code:

Sheets("Data Today").Range("B37:F64").Copy

et_33 · #2 10-05-2022, 07:47 AM

You're right I could definitely shorten it down this is just a macro from a previous employee so I haven't really messed with it. Still does not solve the copying of text string "Test Slide Distribution" to the clipboard at the end however.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
WORD MACRO COPY/PAST from clipboard	rachidlea	Word VBA	0	11-16-2021 09:38 AM
Need to copy specific formated text from Word and paste from clipboard into a console application	Userx	Word VBA	0	10-09-2020 05:58 AM
Search for specific data in a text string	teligence	Excel	1	05-20-2017 11:51 AM
Find & selected paras with highlighted text & copy to clipboard	marceepoo	Word VBA	1	09-14-2012 08:20 PM
Mark text in a text box and copy to clipboard (with button)	ArthurM	PowerPoint	4	02-19-2012 11:33 AM