![]() |
worktime function
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 |
All times are GMT +1. The time now is 04:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com