I'm trying to access some named ranges from with a VBA function.

For Example, I've a column of Cells (A3:A12) name "DataIn"

In my VBA Function GetData() I have
Dim Cell as Range

For each Cell in DataIn

' some Code

Next Cell

Well, this doesn't work. How can I address "DataIn?"

Thank you...

Try

Dim Cell As Range
For Each Cell In Range("DataIn")
'some code
Next Cell

If this post helps click Yes
---------------
Jacob Skaria


"Bruce A. Julseth" wrote:

> I'm trying to access some named ranges from with a VBA function.
>
> For Example, I've a column of Cells (A3:A12) name "DataIn"
>
> In my VBA Function GetData() I have
> Dim Cell as Range
>
> For each Cell in DataIn
>
> ' some Code
>
> Next Cell
>
> Well, this doesn't work. How can I address "DataIn?"
>
> Thank you...
>
>
> .
>

For Each Cell In Worksheets("Sheet1").Range("DataIn").Cells
....do something
Next

"Bruce A. Julseth" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> I'm trying to access some named ranges from with a VBA function.
>
> For Example, I've a column of Cells (A3:A12) name "DataIn"
>
> In my VBA Function GetData() I have
> Dim Cell as Range
>
> For each Cell in DataIn
>
> ' some Code
>
> Next Cell
>
> Well, this doesn't work. How can I address "DataIn?"
>
> Thank you...
>

"Jacob Skaria" <(E-Mail Removed)> wrote in message
news:6115F75E-8FFD-44B0-ABD0-(E-Mail Removed)...
> Try
>
> Dim Cell As Range
> For Each Cell In Range("DataIn")
> 'some code
> Next Cell
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "Bruce A. Julseth" wrote:
>
>> I'm trying to access some named ranges from with a VBA function.
>>
>> For Example, I've a column of Cells (A3:A12) name "DataIn"
>>
>> In my VBA Function GetData() I have
>> Dim Cell as Range
>>
>> For each Cell in DataIn
>>
>> ' some Code
>>
>> Next Cell
>>
>> Well, this doesn't work. How can I address "DataIn?"
>>
>> Thank you...
>>
>>
>> .
>>

Yah, that was the problem. I "FORGOT" to wrap the Named Column in Quotes.

Thanks....