View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Ref cells in diff wrkshtss

To better attract responses, post the formula(s) ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Figure It Out wrote:
I am trying to set up a formula to have one cell reference another in a
different worksheet. I already have others that work fine, but one particular
range will not work. I keep getting this error #VALUE! or it just puts in the
name of the worksheet I am trying to reference when I change the number
category to either General or Text.