When a user selects an item from a list box I would like
it to go and select and range of numbers from a sheet and
insert it in the box, I tried doing this

Sheets("Book vs Plan").Range("d50:o50") = Sheets
("plan").Range("d4:o4")

but that failed, no error messages but no data either.

Can someone help me with the correct syntax

Thanks

Perhaps if you explain your problem a little more clearly ...

--

Vasant

"Nigel Bennett" wrote in message
...
When a user selects an item from a list box I would like
it to go and select and range of numbers from a sheet and
insert it in the box, I tried doing this

Sheets("Book vs Plan").Range("d50:o50") = Sheets
("plan").Range("d4:o4")

but that failed, no error messages but no data either.

Can someone help me with the correct syntax

Thanks