I have the following code:
Please Login or Register to view this content.
when the contents of colulmn1 on sheet1 has exactly 7 entries then i get a type mismatch error. When there are more than 7 everything works out fine.
I want to put into the array all the elements in col1 of sheet1 that are from row 7 on down.
any ideas? i am enclosing a file as well.
Bookmarks