Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
object error
I am receiving an object error when I run this procedure. I'm not sure why.
It does the calculation. I have posted the procedure that calls the function. Thanks Private Sub DivideCells() Dim value As Double value = 1000 DivideRange(Range("C15:V15"), value) = Range("C15:V15").value End Sub Function DivideRange(myRange As Range, myValue) Dim myCell As Range For Each myCell In myRange myCell.value = myCell / myValue Next myCell End Function |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
object error
Hi Monique -
You've probably tried this. Change DivideRange to a PRIVATE SUB accepting arguements then call DivideRange in your code. It gets you the same result without the error. Mike Sub DivideCells() Dim value As Double value = 1000 Call DivideRange(Range("c15:g15"), value) End Sub Private Sub DivideRange(myRange As Range, myValue) Dim myCell As Range For Each myCell In myRange myCell.value = myCell / myValue Next myCell End Sub "Monique" wrote: I am receiving an object error when I run this procedure. I'm not sure why. It does the calculation. I have posted the procedure that calls the function. Thanks Private Sub DivideCells() Dim value As Double value = 1000 DivideRange(Range("C15:V15"), value) = Range("C15:V15").value End Sub Function DivideRange(myRange As Range, myValue) Dim myCell As Range For Each myCell In myRange myCell.value = myCell / myValue Next myCell End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error | Excel Programming | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
Runtime Error 1004 -- Application Defined or Object Defined Error | Excel Programming |