Difficulties with named range

G

Gerry

I have a single cell named BRHCTS in several excel files. It
indicates the bottom-right-hand-corner of the range I am interested
in. The upper right hand corner is always the cell A10. Therefore,
the range I want to copy from each of my files (into a consolidated
worksheet) is "A10:BRHCTS".

Can anyone advise me how I can do that without opening the source
files?

Thanks.
 
B

Barb Reinhardt

If you want to select/copy/do something on the range in vba, you'll need
something like this

Range("A10:"&Range("BRHCTS").address)

If you want to copy these ranges from multiple closed workbooks, the only
way is to open them. If that's not what you're asking, come back.

I've used code that copies multiple worksheet ranges into one worksheet, but
I can't seem to find it right now. Maybe someone else knows the link to it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Aggregating Data in Fifteen Unopened Spreadsheets into SingleConsolidated Sheet 1
What does a red triangle mean? 6
Modify a range name with vb 2
Chart with Named Range error 1
Excel 2003: numbers copied from website are treated as text 3
Define range to avoid circular reference 4
Go To a Named Range (2nd posting) 4
Cannot paste named range formula 3

Top