problem with excel vba copy/paste. can anyone help?
 

i get an inconsistent error... more like a fluke.... that happens once in a
blue moon.
The code below results in an incomplete paste. Only the 1st cell is pasted
and the rest are blank?!!!

'copy
dataWS.Activate
Set xlrng = dataWS.Range(dataWS.Cells(Row, 5), dataWS.Cells(Row, 256))
xlrng.Select
Application.CutCopyMode = False
Selection.Copy

'paste
xlws.Activate
xlws.Cells(writerow, 1).Select
ActiveSheet.Paste
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

Ideas anyone?

problem with excel vba copy/paste. can anyone help?
 

'copy
dataWS.Activate
Set xlrng = dataWS.Range(dataWS.Cells(Row, 5), dataWS.Cells(Row, 256))
xlrng.Select
Application.CutCopyMode = False
Selection.Copy
'paste
xlws.Activate
xlws.Cells(writerow, 1).Select
On Error Resume Next
ActiveSheet.Paste
Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
' if err.Number < 0 then
' msgbox "Selection can not be pasted"
' end if
on Error goto 0

--
Regards,
Tom Ogilvy


"vbadude" wrote:

i get an inconsistent error... more like a fluke.... that happens once in a
blue moon.
The code below results in an incomplete paste. Only the 1st cell is pasted
and the rest are blank?!!!

'copy
dataWS.Activate
Set xlrng = dataWS.Range(dataWS.Cells(Row, 5), dataWS.Cells(Row, 256))
xlrng.Select
Application.CutCopyMode = False
Selection.Copy

'paste
xlws.Activate
xlws.Cells(writerow, 1).Select
ActiveSheet.Paste
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

Ideas anyone?