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