View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default copy a specified name range

The data that prints out is 55% in all cells...

Is the calc mode accidentally set to Manual?
Check Tools Options Calculation tab

Pl post the actual formula you are using over there
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lori" wrote in message
...
Tried your answer and got a partial response. Here is the data that
should
appear:

55.0% 55.0% 55.0%
30.0% N/A 30.0%
8.0% N/A N/A
N/A
N/A

The data that prints out is 55% in all cells. What could I be doing wrong?

--
Lori