Goto in a sheet
 

Hi!
In a sheet i have:
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7
where 7 are 13-08-2007 - 06-08-2007
And where 13-08-2007 are = Now()

I a makro i have :
Range ("b11").select but ehat i want is Range ("b11") + The value of C1 in
the sheet where i have, the + is to the right or collumn
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7

Hope someone understand and can help
regrds
alvin

Goto in a sheet
 

Range("B11").Offset(0,Range("C1").Value).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"alvin Kuiper" wrote in message
...
Hi!
In a sheet i have:
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7
where 7 are 13-08-2007 - 06-08-2007
And where 13-08-2007 are = Now()

I a makro i have :
Range ("b11").select but ehat i want is Range ("b11") + The value of C1
in
the sheet where i have, the + is to the right or collumn
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7

Hope someone understand and can help
regrds
alvin

Goto in a sheet
 

Thanks bob

But my value in C1 is in another sheet than B11

Hop you can help

Alvin


"Bob Phillips" skrev:

Range("B11").Offset(0,Range("C1").Value).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"alvin Kuiper" wrote in message
...
Hi!
In a sheet i have:
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7
where 7 are 13-08-2007 - 06-08-2007
And where 13-08-2007 are = Now()

I a makro i have :
Range ("b11").select but ehat i want is Range ("b11") + The value of C1
in
the sheet where i have, the + is to the right or collumn
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7

Hope someone understand and can help
regrds
alvin

Goto in a sheet
 

Range("B11").Offset(0,Worksheets("the_other_sheet_ name").Range("C1").Value).Select


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"alvin Kuiper" wrote in message
...
Thanks bob

But my value in C1 is in another sheet than B11

Hop you can help

Alvin


"Bob Phillips" skrev:

Range("B11").Offset(0,Range("C1").Value).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"alvin Kuiper" wrote in message
...
Hi!
In a sheet i have:
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7
where 7 are 13-08-2007 - 06-08-2007
And where 13-08-2007 are = Now()

I a makro i have :
Range ("b11").select but ehat i want is Range ("b11") + The value of
C1
in
the sheet where i have, the + is to the right or collumn
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7

Hope someone understand and can help
regrds
alvin

Goto in a sheet
 

try it this way. BTW you probably do NOT need to select that cell to do
something
Sub myval()
mv = Sheets("othersheetname").Range("c1")
Range("B11").Offset(0, mv).Select
'Range("B11").Offset(0, mv).copy range("c12")
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"alvin Kuiper" wrote in message
...
Thanks bob

But my value in C1 is in another sheet than B11

Hop you can help

Alvin


"Bob Phillips" skrev:

Range("B11").Offset(0,Range("C1").Value).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"alvin Kuiper" wrote in message
...
Hi!
In a sheet i have:
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7
where 7 are 13-08-2007 - 06-08-2007
And where 13-08-2007 are = Now()

I a makro i have :
Range ("b11").select but ehat i want is Range ("b11") + The value of
C1
in
the sheet where i have, the + is to the right or collumn
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7

Hope someone understand and can help
regrds
alvin

Goto in a sheet
 

Thanks Bob
Its working

Alvin


"Bob Phillips" skrev:

Range("B11").Offset(0,Worksheets("the_other_sheet_ name").Range("C1").Value).Select


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"alvin Kuiper" wrote in message
...
Thanks bob

But my value in C1 is in another sheet than B11

Hop you can help

Alvin


"Bob Phillips" skrev:

Range("B11").Offset(0,Range("C1").Value).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"alvin Kuiper" wrote in message
...
Hi!
In a sheet i have:
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7
where 7 are 13-08-2007 - 06-08-2007
And where 13-08-2007 are = Now()

I a makro i have :
Range ("b11").select but ehat i want is Range ("b11") + The value of
C1
in
the sheet where i have, the + is to the right or collumn
a1 = 06-08-2007
b1 = 13-08-2007
c1 = 7

Hope someone understand and can help
regrds
alvin