LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 84
Default click on cell it goes to formula location??

i have never seen this or anythign like this...
my workbook has 8 sheets "sheet 2-8" are fine
when you double click on a cell with an equation the equation comes up and
you can edit it.

on sheet 1 however, when you double click on a cell with an equation it
takes you to the cell
example: sheet1!A1 "=sheet4!b2", when you double click on the cell it takes
you to sheet4!b2

any ideas

thanks in advance
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
a formula that return the cell location in a range danpt Excel Discussion (Misc queries) 5 May 3rd 09 12:43 PM
Using Dynamic Cell Address As Formula Location [email protected] Excel Worksheet Functions 4 March 6th 07 06:37 AM
Inserting after specific location on right click menu [email protected] Excel Discussion (Misc queries) 1 July 26th 06 11:29 PM
Changing Cell location within a formula woknick[_2_] Excel Programming 3 July 28th 04 02:16 PM
How can a formula get the location of the cell it is placed in? Bernard[_4_] Excel Programming 3 February 16th 04 02:35 PM


All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"