range as variable
 

Range("C33").Select

is there a way to may range a variable ?

Sparky

range as variable
 

.... 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

range as variable
 

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

range as variable
 

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

range as variable
 

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