Jon, thanks again for all your help,
Cheers,
Ian.
"Jon Peltier" wrote:
Ian wrote:
Hi Jon,
Neat, very neat! That's just what I'm looking for and not a line of code in
sight. I followed through your explanations on the pages of your site and was
able to follow your thinking perfectly.
Great!
I guess that if you want to point to
a worksheet in a different Excel file you just need to construct the INDIRECT
function to reflect it's path?
Correct. It's possible to reference cells in a closed workbook, but I
have a nagging suspicion the address has to be hard coded, not
constructed using INDIRECT. A quick test will show you the answer. If
you keep the files open, no big deal.
Just out of interest, do you know how many
worksheets you can have in a workbook?
Limited by available memory, which doesn't mean how many gigs of ram you
have, but rather how much of it Excel is designed to use (relatively
little by today's standards).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______