Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
AB2537
 
Posts: n/a
Default Cell References Changed

Using auto filter, I seleted rows that had to be deleted. Afterwards, I
removed all filters. I noticed the linked cells in one column had changed.
(example - column A7 was not equal to B7 - but B293).

No other links were affected in the worksheet. I have no idea why only one
column was affected.

The only difference w/the affected column was that the link refers to the
Worksheet & row # example "Input!B7" instead of "B7".

Any ideas


Reply
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
how do i copy a formula when cell references r not together jon104 New Users to Excel 1 January 9th 06 03:25 PM
Count on cell for each time it is changed Jelinek Excel Discussion (Misc queries) 3 January 9th 06 02:22 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Cell References in Functiona Mark T. Excel Worksheet Functions 1 December 11th 04 06:49 PM
Excel: how to formulate conditional cell references centraloffice Excel Worksheet Functions 1 December 10th 04 08:57 PM


All times are GMT +1. The time now is 11:45 PM.

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

About Us

"It's about Microsoft Excel"