About Us

scott

How can I simplify this code to a more compressed format?

Sheets("WK1").Select
Range("B2:H8").Select
Selection.Copy
Sheets("Web Sheet").Select
Range("B63").Select
Selection.PasteSpecial Paste:=xlPasteValues

Sheets("WK1").Select
Range("B12:H18").Select
Selection.Copy
Sheets("Web Sheet").Select
Range("B73").Select
Selection.PasteSpecial Paste:=xlPasteValues

Sheets("WK1").Select
Range("B22:H28").Select
Selection.Copy
Sheets("Web Sheet").Select
Range("B83").Select
Selection.PasteSpecial Paste:=xlPasteValues

Sheets("WK1").Select
Range("B32:H38").Select
Selection.Copy
Sheets("Web Sheet").Select
Range("B93").Select
Selection.PasteSpecial Paste:=xlPasteValues

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I simplify a VB code??????	hoyos	Excel Discussion (Misc queries)	1	November 6th 09 09:06 PM
Simplify code	Inkel	Excel Worksheet Functions	3	March 27th 09 05:52 PM
Need to simplify code	alexwren	Excel Discussion (Misc queries)	7	August 15th 06 08:07 PM
simplify code	matt	Excel Discussion (Misc queries)	3	September 28th 05 11:53 PM
Help to simplify code.	Michael Beckinsale	Excel Programming	0	September 2nd 03 10:26 AM

Menu

About Us