Excel VBA Help - Range of data populating a sheet depending on which listbox case you pick

So I have a list of vendors, lets say Vendor 1, Vendor 2, Vendor 3. The vendors with description, pricing, and part numbers are on sheet 2. I want sheet 1 to contain a listbox that will make things a little easier to sort through. By selecting the listbox case (or selection), it will only populate data (on sheet 1) of the vendor I selected.

Vendor 1 has data throughout the range of A1:P12.
Vendor 2 has data throughout the range of A13:P26
etc..You get my point here..

My problem is that when doing a select case argument, it is throwing back errors when I type this code in:

quote:

---

Select Case listbox1.listindex

Case 0

sheet1.range("A1:P12").value = Sheet2.range("A1:P12")

Case 1

sheet1.range("A13:P26").value = Sheet2.range("A13:P26")

End Select

End Sub

---

Any help is appreciated. It appears that calling out a range of multiple cells this way is not correct.