Don Guillett wrote:
Lots of ways. Detail?

Range("C33").Select

is there a way to may range a variable ?

Sparky

I have cellthat i type qty number in

and from that i populate from c33 with detail of a product based on that
qty

so what i want to do is

lg 17 qty =2
and lg 20 qty = 0
the c33 & c34 will read LG 17

but if lg 17 qty =1
and lg 20 qty = 2
then cells c33 wil read lg 17
cell c34 will rad lg 20
cell c35 will rad lg 20

sparky