Using Cell name in vba: Newbie question

[mtheriault2000]

Hello

Well not a true newbie, but i did not code in vba since a while and I'm stuck with a small problem. I got a blank and I'm a bit shy to ask

I got 2 worksheets
1: Data_IN_Out
2: Sheets2

In VBA, under the Sheets2 code, I want to use the value of a cell in sheet "Data_In_Out". I want to use is cell name ("iProposedQty")

Range("IproposedQTY").Value = 5 is referenced under the sheet("Data_In_Out") and I want to use it in a line of code under Sheets2

Hope I'm clear enough in my not so good English and programmer language

Martin

 

[al_b_cnu]

Hi,

Try

sheets( "Data_In_Out").Range("iProposedQty")

 

[JackDanIce]

Do you mean something like:

Sheets("Sheet2").Range("A1") = Range("IproposedQTY")

If your name has been defined as a global name within your workbook (usually default as) then this should work.

 

[mtheriault2000]

Thanks JackDanIce
Thank al_b_cnu

JackDanIce,

Do you mean something like:

If your name has been defined as a global name within your workbook (usually default as) then this should work.

Hello JackDanIce


How to I define as a global name. I defined my names using Selection tool bar Formula,Created from selection. Then I want to use those created name in VBA. As I understand now, these created name are not global.