excel vba: Range gives Argument Not Optional error message

Viewed 7523

In excel vba I'm tryin to select a range of values starting in Cell"O2", (O from Oyster) down to the end of the sheet, I'm trying:

 Range("O2", Range.End(xlDown))

But that fails with Argument Not Optional. What am i doing wrong? I'm using Excel 2010.

3 Answers
Related