Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I seem to be running into the 1004 error on what I thought would be
something simple. I have created 4 names one of which is "Clothing", it refers to cells B4 to B8. I want to simply place the arrData into each of the five cells. I can't get past that line setting the range object. I thought setting range objects was easy. The range is already named what is causing this error? A piece of the offending code follows: Is there some "rule of thumb" to follow when setting and using range objects, I always seem to be getting thrown with them. Thanks David. Public Sub ApplyData() Dim i As Integer Dim j As Integer Dim rng As Range Sheets("Master").Activate Set rng = Range("Clothing") ' Can't get past this line rng.Cells(1) = arrData(0, 0) rng.Cells(2) = arrData(0, 1) rng.Cells(3) = arrData(0, 2) rng.Cells(4) = arrData(0, 3) rng.Cells(5) = arrData(0, 4) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error '1004' - the specified value is out of range. | Excel Programming | |||
setting range().hidden=True causes range error 1004 | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Run-time error '1004' running to excel objects at once | Excel Programming | |||
Category Names runtime error 1004 | Excel Programming |