Goto in a sheet

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

Thanks bob

But my value in C1 is in another sheet than B11

Hop you can help

Alvin


"Bob Phillips" skrev:

 

[Bob Phillips]

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)

 

[Don Guillett]

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

 

[Guest]

Thanks Bob
Its working

Alvin


"Bob Phillips" skrev: