View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dean.brunne@lion-nathan.com.au is offline
external usenet poster
 
Posts: 15
Default Fill Array not working

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))