Hi this is my fiirst time programming vba with excel.

My problem is that i can't seem to use the cell i have refered to in a
formula.

When i write my initials in say cell A10 then excel puts in the Date =
format(now, .....) in cell B10.

I want to refer to the cell next to B10 which is C10 and sum C10 with
say C1. I use offset to refer to the cell next to B10 but i don't want
to refer to the value in C10 just the cell, so I can do a sum command
and save the result in another cell

[E4].Value = Application.Sum([C10:C1]) But i don't know C10 other than
it is next to B10...and i can't use that in the formula...

sorry its a bit hard to explain hope you understand me anyways.