Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveCell.Formula Help
Hi,
I have a String by name fieldtemp which is equal to A3,B3,D3,F5,J7 (and so on along with the commas) Now I want to insert a formula into a cell which is the average of the values in A3,B3,D3,F5,J7 etc I did the following: ActiveCell.FormulaR1C1 = "=AVERAGE(fieldtemp)" But instead of assigning the formula as =Average(A3,B3,D3,F5,J7) it does =Average(fieldtemp). It does not seem to expand the value of fieldtemp. Please help. Thanks in advance Srikanth *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveCell.Formula Help
Hi
ActiveCell.FormulaR1C1 = "=AVERAGE(" & fieldtemp & ")" -- Regards Frank Kabel Frankfurt, Germany Srikanth Ganesan wrote: Hi, I have a String by name fieldtemp which is equal to A3,B3,D3,F5,J7 (and so on along with the commas) Now I want to insert a formula into a cell which is the average of the values in A3,B3,D3,F5,J7 etc I did the following: ActiveCell.FormulaR1C1 = "=AVERAGE(fieldtemp)" But instead of assigning the formula as =Average(A3,B3,D3,F5,J7) it does =Average(fieldtemp). It does not seem to expand the value of fieldtemp. Please help. Thanks in advance Srikanth *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
ActiveCell.Formula | Excel Programming | |||
ActiveCell.Formula Syntax | Excel Programming | |||
activecell.formula syntax | Excel Programming | |||
Formula with an ActiveCell | Excel Programming |