error: Method or Data Member not found

**CRIMEDOG** · 07-26-2013, 10:42 AM

Please Login or Register  to view this content.

This part of the code .Range is highlighted with the error message: Method or Data Member not found

Please Login or Register  to view this content.

What am I doing wrong?

Whole Macro:

Please Login or Register  to view this content.

**Norie** · 07-26-2013, 10:48 AM

Workbooks don't have a Range property.

You need to specify which worksheet in the workbook you want to refer to.

If it's the active sheet replace ThisWorkbook with ThisWorkbook.ActiveSheet.[

**CRIMEDOG** · 07-26-2013, 11:01 AM

That was it - I had changed the Activesheet to ThisWorkbook to avoid it trying to run on a different workbook that is open at the same time.
Then I forgot to add back the ActiveSheet. (although I did change it to Worksheets("Entry") since this is the only sheet I want it to run on.)

Thanks for the quick response - I was not seeing it.