Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm trying to soup up a loop I have, but I'm getting the following error message: Wrong Number of Arguments or Invalid Property Assignment I've been through Help and The Books, but I can't determine what's wrong. Thanks, Joe Sub MOO() Dim rng As Range Set rng = Range(ActiveCell, ActiveCell.End(xlDown)) j = 0 For Each cell In rng If cell.Value < cell.Offset(-1).Value Then CreatePSFrontLabel cell, j j = j + 1 End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get a Yes/No message box to loop | Excel Discussion (Misc queries) | |||
Error message when using the Solver in a VBA macro loop | Excel Programming | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |