View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DaveO DaveO is offline
external usenet poster
 
Posts: 94
Default Works every second time

Without seeing the rest of the code, I'm going to guess that the 'Selection.'
part is the bit thats causing you your issue here.

If you post the rest of at least post how the selction is derived it may help.

HTH.

"hih" wrote:


Hello!
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

In one of my Sub's this Paste-function only work every second time.
Can you help me to make it work -every- time?

hih


--
hih
------------------------------------------------------------------------
hih's Profile: http://www.excelforum.com/member.php...o&userid=30672
View this thread: http://www.excelforum.com/showthread...hreadid=503315