Error 380: could not set the rowsource property. invalid property value when changing the rowsource property

Hi,

VBA/Excel issue

I am encountering an issue where I get the error "could not set the rowsource property. invalid property value".

I have a listbox and change the elements it refers to depending on what options a user selects.

The first time I set the RowSource property, it works perfectly. If I add items to the referred worksheet and update the Rowsource property everything is fine. When I go to change it after adding something to the original list, then I get the error.

For example, I cannot change the Rowsource property from "Element1!G122:I124"
to "Element3!Q122:S128" - get the error.

In the watch window I try to forcably change it to "Element1!G122:I123" (ie. referring to one less row - a minor change), and the debugger gives me the same error. However I can change it to "" (Null)

Any ideas?

Thanks

Greg