VBA for excel

[chopin33]

Hi,
I am trying to update the content of a cell by using the code ActiveCell.FormulaR1C1 = formula, in which "formula" is the string "= 2 + median(...values)". However I kept on getting the "Application-defined or object defined" error. What is the reason for this error? I'm new to VBA and any help is greated appreciated. Thanks!

Xian

 

[bryanbayfield]

Median isn't a VBA function. However, you can access it through the

Application.WorksheetFunction

object, ie

Application.WorksheetFunction.Median(arguments)

All the other functions in Excel can similarly be accessed in this way.

Hope this helps.

SuperBry!

 

[SkipVought]

Hi, chopin33,

Are you sure that a cell is selected, and not some other object? This works...

Sub atest()
    ActiveCell.FormulaR1C1 = "=2+ median(2,3,4,5)"
End Sub

Hope this helps

Skip,
SkipAndMary1017@mindspring.com

 

[DaleWatson123321]

...a bit of an "assist" (with tongue firmly in cheek)

This also works (i.e. without the "R1C1&quot

Sub atest()
ActiveCell.Formula = "=2+ median(2,3,4,5)"
End Sub

Welcome back, Skip !!! ;-)

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[bryanbayfield]

Actually, Skip is right there.

It's been one of those days! SuperBry!

 

[chopin33]

the code activeCell.formulaR1C1 = "2 + median(...)" worked fine on its own, but caused errors when I combined it with a bunch of other code. Maybe there's some error in the other part?

Xian

 

[SkipVought]

Again, you need to look at what object has been selected prior to your statement. Skip,
SkipAndMary1017@mindspring.com