| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Array not working
Dim MyArray As Variant MyArray = Worksheets("TEST").Range("A2", Range("A100").End(xlUp)).Value MsgBox LBound(MyArray) & vbCr & UBound(MyArray) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware wrote in message Hi, The following array code gives me an error message Run time error 1004 "Application defined or object defined error" How do I fix? Thanks - Dean MyArray = Worksheets("TEST").Range(Range("A2"), Range("A100").End(xlUp)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill series not working as expected | Excel Discussion (Misc queries) | |||
| Day of week Fill down column not working | Excel Worksheet Functions | |||
| how do i fill an array? tia | Excel Programming | |||
| fill array | Excel Programming | |||
| fill down array to last available row | Excel Worksheet Functions | |||
Threaded Mode
