Help with referenced sheet (sorry for dups)

[Bill L]

Hi all,

I am attempting to feed data into a cell on sheet ABC that comes from
another sheet that will be created programmatically (call it sheet XYZ). I
start by creating the reference with sheet XYZ already existing, so that I
can pick the cells I want off of it. I then delete sheet XYZ. My cells on
ABC all then become #REF, which is okay with me. I save and close. I then
run the program that takes some data, opens my excel file, and (re)creates
sheet XYZ and puts the data I want onto it.

The problem is that all of my cells on ABC that reference XYZ keep the #REF
until I double click in the cell and hit 'Enter'. Neither Refresh or
Calculate Sheet work.

Any ideas?

Thanks!

Bill

 

[Don Guillett]

To get xyz!b4

=INDIRECT("xyz!B"& ROW(A4))

 

[Bill L]

Worked like a charm!

Thanks!!

To get xyz!b4

=INDIRECT("xyz!B"& ROW(A4))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Glad to help