Hello World.... Elizaaabeeethhh.....<br>DougP..................<br><br>anyway... as I was saying....<br><br>I created an Excel application that calculates monthly payments. it works fine on my computer when I took the file to the user. it opens fine but when you sort the cell that contains the number of payments displays the error #Name?<br><br>I tried in different computers and the only one displaying it right is mine.<br><br>I checked Excel versions (same)<br><br>any ideas....as for why...or how to fix it?<br><br>The cells involved in the problem are:<br><br>L4: =YEARFRAC(J4,I4,0)*12<br>J4: 12/01/98<br>I4: 04/01/98<br><br>Like I said they work fine until I filter<br><br>Heeeeeeeeeelp! <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
#Name? error (only on others computers) 1
- Thread starter Dumboy
- Start date
-
1
- #2
- Thread starter
- #3
Thanx... Bob... that was it....<br><br>I voted for you ......<br><br>later.... <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!
- Status
Similar threads
- Locked
- Question
