$$Excel-Macros$$ Re: cell formula

2013-04-16 Thread colmkav
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) .

$$Excel-Macros$$ Re: cell formula

2013-04-15 Thread Lalit Mohan Pandey
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