Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to use this macro but am having an application, unknown object
error: Option Explicit Sub round_made_easy() Dim myCell As Range For Each myCell In Selection.Cells myCell.Formula = "=Round(" & myCell.Formula & ",2)" Next myCell End Sub Now when I try the above it gives me an application error. But with the following code that you gave me it works great. Option Explicit Sub round_made_easy() Dim myCell As Range For Each myCell In Selection.Cells myCell.Formula = "=Round(" & myCell.Value & ",2)" Next myCell End Sub why won't it work for a cell that is =1258/4569871 and keep the 1258/4569871 in the cell's formula of =Round(1258/4569871, 2) ??? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
Error 1004: Application or Object Defined Error | Excel Programming | |||
Error 1004, Application-definded or object-defined error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |