HI
i have this code:
Range("perioder!$H$" & start).Value
where start is a variable
now i also want to change $h$ to a variable
but i Can't make it right
Help
Alvin

Where c col is a number 1..256.

Sheets("perioder").cells(start,Col).Value


"alvin Kuiper" wrote:

> HI
> i have this code:
> Range("perioder!$H$" & start).Value
> where start is a variable
> now i also want to change $h$ to a variable
> but i Can't make it right
> Help
> Alvin
>

Try using the cells command instead, it is much easier to call both a row and
column. The column does have to be a number reference.

Sheets("perioder").Cells (start,column number).value
--
If this helps, please remember to click yes.


"alvin Kuiper" wrote:

> HI
> i have this code:
> Range("perioder!$H$" & start).Value
> where start is a variable
> now i also want to change $h$ to a variable
> but i Can't make it right
> Help
> Alvin
>

Try this

Dim MyCell As String
Dim Start As Long
MyCell = "H"
Start = 1
x = Range("perioder!" & MyCell & Start).Value

Mike

"alvin Kuiper" wrote:

> HI
> i have this code:
> Range("perioder!$H$" & start).Value
> where start is a variable
> now i also want to change $h$ to a variable
> but i Can't make it right
> Help
> Alvin
>

Hi Alvin

One way, with colno as the variable holding the column number required (8),
then
sheets("perioder").cells(start , colno).Value

--
Regards
Roger Govier

"alvin Kuiper" <(E-Mail Removed)> wrote in message
news:0FF67427-3FDB-42DE-9E36-(E-Mail Removed)...
> HI
> i have this code:
> Range("perioder!$H$" & start).Value
> where start is a variable
> now i also want to change $h$ to a variable
> but i Can't make it right
> Help
> Alvin
>

Sheets("perioder").Cells(start,8).value

OR

strCol = "H"
Range("perioder!" & strCol & start).Value

OR

strCol = "H"

Sheets("perioder").cells(start,strCol).Value

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


"alvin Kuiper" wrote:

> HI
> i have this code:
> Range("perioder!$H$" & start).Value
> where start is a variable
> now i also want to change $h$ to a variable
> but i Can't make it right
> Help
> Alvin
>

Thanks to all

And Jacob I give a beer if you ever come to denmark
Just write
Alvin


"Jacob Skaria" skrev:

> Sheets("perioder").Cells(start,8).value
>
> OR
>
> strCol = "H"
> Range("perioder!" & strCol & start).Value
>
> OR
>
> strCol = "H"
>
> Sheets("perioder").cells(start,strCol).Value
>
> --
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "alvin Kuiper" wrote:
>
> > HI
> > i have this code:
> > Range("perioder!$H$" & start).Value
> > where start is a variable
> > now i also want to change $h$ to a variable
> > but i Can't make it right
> > Help
> > Alvin
> >

Thanks Alvin for the feedback and offer..

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


"alvin Kuiper" wrote:

> Thanks to all
>
> And Jacob I give a beer if you ever come to denmark
> Just write
> Alvin
>
>
> "Jacob Skaria" skrev:
>
> > Sheets("perioder").Cells(start,8).value
> >
> > OR
> >
> > strCol = "H"
> > Range("perioder!" & strCol & start).Value
> >
> > OR
> >
> > strCol = "H"
> >
> > Sheets("perioder").cells(start,strCol).Value
> >
> > --
> > If this post helps click Yes
> > ---------------
> > Jacob Skaria
> >
> >
> > "alvin Kuiper" wrote:
> >
> > > HI
> > > i have this code:
> > > Range("perioder!$H$" & start).Value
> > > where start is a variable
> > > now i also want to change $h$ to a variable
> > > but i Can't make it right
> > > Help
> > > Alvin
> > >