reference a column

[Svgmassive]

I want to create a name range WK_Col which would be column a to use in formula (vba) what's the best approach.Thanks

 

[marka87uk]

Select the column and type the name WK_Col into the Name Box.

 

[Svgmassive]

That i understand. The problem is this.I have a name range call Wk_Col which references =Sheet1!$A:$A.the problem is this when i reference a range in vba
Range(Cells(5, [Wk_Col].column), Cells(8, [Wk_Col].Column)) i have to use the [Wk_Col].Column instead of just [Wk_Col].
thanks

 

[Marcelo Branco]

Maybe this

Dim rng As Range
   
Set rng = Range([Wk_Col].Cells(5), [Wk_Col].Cells(8))

HTH

M.

 

[Rick Rothstein]

Maybe this

Dim rng As Range
 
Set rng = Range([Wk_Col].Cells(5), [Wk_Col].Cells(8))

Or even this...

Set Rng = [Wk_Col].Rows("5:8")

 

[Marcelo Branco]

Or even this...

Set Rng = [Wk_Col].Rows("5:8")

Yes and simpler.

M.

 

[villy]

That i understand. The problem is this.I have a name range call Wk_Col which references =Sheet1!$A:$A.the problem is this when i reference a range in vba
Range(Cells(5, [Wk_Col].column), Cells(8, [Wk_Col].Column)) i have to use the [Wk_Col].Column instead of just [Wk_Col].
thanks

You can try...

Set Wk_Col=Sheet1.Range("A:A") or
Set Wk_Col=Sheet1.Range("A")

then...

Range(cells(5,Wk_Col),cells(8,Wk_Col))