Two ranges good separatly but not together

**carsto** · 09-25-2017, 09:46 AM

XL2010
I've successfully done this with numerous other workbooks but not these two.

Runtime error 1004

Please Login or Register  to view this content.

The Range is valid because
in the immediate pane with EACH RESPECTIVE WORKBOOK ACTIVE
I can successfully select each half in this manner:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**xlnitwit** · 09-25-2017, 10:12 AM

Hi,

You must qualify the Cells properties with the same worksheet object as the Range property

Please Login or Register  to view this content.

Using a With block or a variable would be tidier.

**carsto** · 09-25-2017, 10:46 AM

THANK YOU!
I took all my variables out in case they were causing the problem.
In the past I have used Named Ranges (with Workbook scope) to enter values, which eliminated the need for the seemingly redundant qualifying.

Two ranges good separatly but not together

LinkBack

Thread Tools

Rate This Thread

Display

Two ranges good separatly but not together

Re: Two ranges good separatly but not together

Re: Two ranges good separatly but not together

Thread Information

Users Browsing this Thread

Similar Threads

Creating 'Network IP' and 'Subnet IP' Ranges from IP CIDR subnets ranges

[SOLVED] Find and bring product code separatly in another coloumn

Extracting Numbers and alphanumerics separatly from a cell

Count rows with multiple criteria; comparing ranges and ranges to value in one statement

Open Excel separatly

Worksheet_Change procedure & multiple named ranges: specific cells/ranges fail to update

Copy data in named ranges to a newer version of the same template to identical ranges

Bookmarks

Bookmarks

Posting Permissions