ActiveCell.FormulaR1C1 = "=LeggTilTid(R[-1]C,RC[-1]
I have a worktimefunction selection (R[-1]C is date and time (18,03,05
07:01:01)
selection RC[-1] is houers add to date
and time.
Some time I add hollydays as this:
ActiveCell.FormulaR1C1 = "=LeggTilTid(R[-1]C,RC[-1]+1 or 15 or what ever,
this I do manualy. I want do du this by VBA, I have created a smal calender
with difrent hollysdays.
I have writen a sub wher I do evrything inside Vba and put the resalt to
the cell, but then I dont have the function only the resalt in the cell.

I also have writen a sub wher
ActiveCell.FormulaR1C1 = "=LeggTilTid(R[-1]C,RC[-1]+Klokkeslett!R12C4"
but when I add +1 or.... it taks long time for the function to calculate,
sometime it never stop.
Is there a way to put the +1 or...... direct to the function insted bye
VBA????
Sorry, may spelling is bed.

Regards
Yngve