| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.Formula = help needed
How do I get this formula translated in VBA ".Formula =" format?
=SUM(INDIRECT("AB"&ROW()-COUNTA(Classes)&":AB"&ROW()-1)) -- David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.Formula = help needed
All you need to do is put the whole thing in quotes and then (to deal with
quotes inside quotes) double up the inner quotation marks. For cell A1, e.g.: Range("A1").Formula = "=SUM(INDIRECT(""AB""&ROW()-COUNTA(Classes)&"":AB""&ROW()-1))" -- - K Dales "David" wrote: How do I get this formula translated in VBA ".Formula =" format? =SUM(INDIRECT("AB"&ROW()-COUNTA(Classes)&":AB"&ROW()-1)) -- David |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.Formula = help needed
?B?SyBEYWxlcw==?= wrote
All you need to do is put the whole thing in quotes and then (to deal with quotes inside quotes) double up the inner quotation marks. For cell A1, e.g.: Range("A1").Formula = "=SUM(INDIRECT(""AB""&ROW()-COUNTA(Classes)&"":AB""&ROW()-1))" Perfect!! I can never seem to get the quotation marks placed right. Many thanks, -- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula needed | Excel Discussion (Misc queries) | |||
| Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
| needed formula | Excel Worksheet Functions | |||
| Formula help needed | Excel Worksheet Functions | |||
| Formula Help Needed | Excel Discussion (Misc queries) | |||
Hybrid Mode
