Posted to microsoft.public.excel.programming

Jef Gorbach[_2_] Jef Gorbach[_2_] is offline

external usenet poster

Posts: 65

range copy and paste special within macro

Untested, but looks like your code segement is trying to:

Range("V24").Hyperlinks(1).Copy
Select Case Range("V22").Value
Case 1: TargetRange = "AW21:BL21"
Case 2: TargetRange = "AW22:BL22"
End Select
Range(TargetRange).PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Special Copy, Paste Special macro	usmc-r70	Excel Programming	3	July 2nd 09 08:12 AM
Copy excel text on a range and paste special to Word	Daniel	Excel Programming	5	March 31st 08 06:52 PM
Copy range in macro using paste special values	Jeff	Excel Discussion (Misc queries)	2	August 20th 07 08:12 PM
Copy and Paste Special Dynamic Range	BigH	Excel Programming	1	February 20th 06 10:16 PM
Select Range every 20 rows copy & paste special	Adam	Excel Programming	1	June 22nd 04 11:43 PM

All times are GMT +1. The time now is 06:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us