Thread: What am I missing here?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick Smith[_2_] Nick Smith[_2_] is offline
external usenet poster
  
Posts: 43
Default What am I missing here?
Using the following code

Dim RngDate As Range
Set RngDate = ThisWorkbook.Worksheets("Summary Report").Range("A" & i)
ThisWorkbook.Worksheets("Summary Report").Range(RngDate).Select

Fails at line 3 with the following error:

Application Defined or object defined error.

Can anyone help me please?

Thanks.

Nick
Reply With QuoteReply With Quote