Saturday 14 September 2013

Object Required error when I clearly have an object

Object Required error when I clearly have an object

Have searched and have come up short on any solutions to this. I am
relatively new to VB for the record. The variable minDate here is declared
in the module outside of the procedure. I have tried declaring it inside
the procedure, using set, let, and passing the argument as a range
variable. Nothing.
Sub SocialTimeSinceFirstComment() ' ' SocialTimeSinceFirstComment Macro '
Range("A11").Select ActiveCell.FormulaR1C1 = "=MIN(SocialTransform!C[4])"
minDate =
Application.WorksheetFunction.Min(Workbook.SocialTransform!.Range("c4").End(xlDown))

No comments:

Post a Comment