Thread: Using a PasteSpecial within a Destination:= line
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
drdavidge drdavidge is offline
external usenet poster
  
Posts: 1
Default Using a PasteSpecial within a Destination:= line

Hye, is it possible to use a PasteSpecial within a Destination:= line?
For example, could this work somehow?

rng.EntireRow.Cut Destination:=Sheets("DO NOT USE").Range("A" &
Sheets("DO NOT USE").Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial
Paste:=xlFormats


--
drdavidge
------------------------------------------------------------------------
drdavidge's Profile: http://www.excelforum.com/member.php...o&userid=36168
View this thread: http://www.excelforum.com/showthread...hreadid=561195

Reply With QuoteReply With Quote