Range("C33").Select

is there a way to may range a variable ?

Sparky

.... may range ...?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Sparky AKA_Sparkticus" wrote in message
k...
Range("C33").Select

is there a way to may range a variable ?

Sparky

Lots of ways. Detail?

--
Don Guillett
SalesAid Software

"Sparky AKA_Sparkticus" wrote in message
k...
Range("C33").Select

is there a way to may range a variable ?

Sparky

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

In its simplest form, you could do something like

Dim Addr As String
Addr = "C33"
Range(Addr).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Sparky AKA_Sparkticus" wrote in message
k...
Range("C33").Select

is there a way to may range a variable ?

Sparky