Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create farmula in excle programming
how to create farmula in excle programming
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create farmula in excle programming
You mean:
Range("A1").Formula = "=SUM(A2:A14)" NickHK "Ajaynagpur" wrote in message ... how to create farmula in excle programming |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create farmula in excle programming
If the cell or/and range is a variable, how to handle then?
Thanks at advance, Viesta "NickHK" wrote: You mean: Range("A1").Formula = "=SUM(A2:A14)" NickHK "Ajaynagpur" wrote in message ... how to create farmula in excle programming |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create farmula in excle programming
Like this you mean:
Dim varRow As Variant Dim varColumn As Variant varRow = 15 varColumn = 25 Cells(varRow , varColumn ).Formula = "=..." 'Or varColumn = "AB" Range("a" & RowNumber & ":" & varColumn & "30").Formula = "=..." NickHK "ViestaWu" wrote in message ... If the cell or/and range is a variable, how to handle then? Thanks at advance, Viesta "NickHK" wrote: You mean: Range("A1").Formula = "=SUM(A2:A14)" NickHK "Ajaynagpur" wrote in message ... how to create farmula in excle programming |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create farmula in excle programming
If it is the range to be summed that is variable, it would be situation
specific, but here is an example of one possible scenario for Sum. set rng = range(Range("A1"),range("A1").end(xldown)) rng(rng.rows.count + 2).formula = "=Sum(" & rng.Address(1,1) & ")" This puts a sum two rows below the last contiguous entry and sums the values above. -- regards, Tom Ogilvy "ViestaWu" wrote: If the cell or/and range is a variable, how to handle then? Thanks at advance, Viesta "NickHK" wrote: You mean: Range("A1").Formula = "=SUM(A2:A14)" NickHK "Ajaynagpur" wrote in message ... how to create farmula in excle programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to put farmula | New Users to Excel | |||
Help with Excle Formula | Excel Discussion (Misc queries) | |||
average in excle | Excel Worksheet Functions | |||
Farmula wrong result | Excel Discussion (Misc queries) | |||
help in excle setting | New Users to Excel |