Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Is there anything wrong with this code? Private Sub CopyData() Dim vArr As Variant, RR As Range Dim SrcRng As Range, DestRng As Range Dim Kiln As String Dim X As Integer, Response As Variant, Style As Variant ' Get Header data Set SrcRng = Worksheets("DataIn").Range("A3").CurrentRegion vArr = SrcRng.Value Worksheets("Report Log").Select Set DestRng = Range("Source") Set RR = Range("Source").Offset(DestRng.Rows.Count, 0).Resize(SrcRng.Rows.Count, 19) RR.Value = vArr <snip End Sub On one particular occasion I had 37 rows of data to copy, and only 34 were copied (plus the error generated below). I've tried this code numerous times with similar results. Run-time error '1004' Application-defined or object-defined error. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error 1004 when setting a Series Collection.Values as Array via VB | Excel Programming | |||
Error '1004' - the specified value is out of range. | Excel Programming | |||
Error 1004 using array in Sheet select. | Excel Discussion (Misc queries) | |||
setting range().hidden=True causes range error 1004 | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming |