application defined or object defined error

Hi,

i have this code that i wrote in excel 2007
its work exelent but when i am trying to run the script in excel 2003 i got an error 1004
applocation defined or object defined error
this code change the datavalidation list dynamicly depands on a value in a cell

i hope that you can help me

shay

Please Login or Register  to view this content.

Hi and welcome to the forum.

Which line of your code gives you the error?

Regards

A few things that I notice

Please Login or Register  to view this content.

Empty is used as an unitialized vaiable. Just use

Please Login or Register  to view this content.

For a validation (between) I expect a Formula like

Please Login or Register  to view this content.

I would not use this : Sheet1.Protect

Instead

Please Login or Register  to view this content.

why have

Please Login or Register  to view this content.

When the strings are "" (empty) ?

I understand that your rng goes upto Q200, but where it could go wrong:

Please Login or Register  to view this content.

Use startPnt = "" and
An integer can take values up to 32,767.

startPnt = Item.Row, so theoretically it can become as large as Cells.rows.Count, which is already 65,536 in XL2003.
This will give an overflow error '6'

Where it goes wrong (I think) is here Range("'List'!Q2:Q200")

Please Login or Register  to view this content.