Excl 2003 - VBA -Formula building and Indirects

  • Thread starter Thread starter C Brandt
  • Start date Start date
C

C Brandt

Just when you think you understand something.....

I am trying to create a formula that will make a cell on one worksheet equal
to a cell on another worksheet (worksheet is determined by a list of
worksheets).

Example List of worksheets:
08-06
09-06
10-06
11-06
12-06
01-07
etc

What I would like the formula in the target cell to look like is
='08-06'!A7
This cell will then be copied down, on the target sheet, to bring over a
block of consecutive data from that worksheet.
For the life of me, I cannot figure out how to generate the formula.
Indirect seems to be the way to go but I cannot get the aposterphes inserted
as it turns the following part of the line into a comment for VB.

Any clues?

Thanks
Craig
 
hi,

did you try
=indirect(address(row number,column number,1,1,a2))

assuming the name of the worksheet is on A2.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"C Brandt" escreveu:
 

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

Count based on multiple criteria 2
Lookup part of a cell's contents and return value of entire cell 2
Excel 2002 : Anway to paste without time values ? 3
Match formulae 1
SUMIF Formula Help 8
Conditional Formating with IF and AND formula 2
Formula in excel 1
Formula to Enter Dates 5

Back
Top