thx
On Monday, April 15, 2013 9:58:30 AM UTC+2, colmkav wrote:
Hi,
I am trying to set the formula of a cell to be the following: =D6
YEAR(MonthEndDate) . MONTH(MonthEndDate) . \Outputs\
However the following code gives this forumula instead: = 'D6'
YEAR(MonthEndDate) .
Change this line
activecell.FormulaR1C1 = =D6 YEAR(MonthEndDate) . rg.value
. \Outputs\
with
activecell.Formula = =D6 YEAR(MonthEndDate) . rg.value .
\Outputs\
On Monday, 15 April 2013 13:28:30 UTC+5:30, colmkav wrote:
Hi,
I am trying to set the formula of a cell to be the