Thu 14 May 2009, 16:37Delegate Chris said...
Chris has attended:
Excel VBA Intro Intermediate course
Functions
When functions were used to generate the totals, they appeared in the spreadhseet as values. Is it possible to insert them as formulae instead of values, so that they can be edited?
Mon 18 May 2009, 08:45
Edited on Mon 18 May 2009, 08:46Trainer Stephen said...
RE: functions
Hi Chris
Thank you for your question
The easiest way to do this is to use the formulaR1C1 method of the range object. For example
ActiveCell.FormulaR1C1 = "=AVERAGE(RC[-4]:RC[-2])"Places a function that calculates the average values in the cells 4 to 2 columns to the left of the active cell. I suggest manually entering some formulae into a worksheet while the macro recorder is on, so that you can get a better feel for the syntax
Regards
Stephen
