Results 1 to 9 of 9

Deleting rows w/out losing references

Threaded View

  1. #1
    Registered User
    Join Date
    09-23-2008
    Location
    Dallas area
    Posts
    3

    Deleting rows w/out losing references

    I have a sheet of data that I'm trying to delete a row from. When I delete the row, all the rows below it change to #REF, and I guess I lose all the references to my formulas. I had a similar sheet of data that I could delete rows from without this happening, so I know it can be done, but how?
    Let me know if any further info is needed to help solve this problem.
    Thank you.
    Last edited by VBA Noob; 09-23-2008 at 02:20 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Deleting Duplicate Rows???
    By jerickson in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-27-2012, 01:02 PM
  2. Deleting duplicate offsetting rows
    By bshbros in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2008, 05:30 PM
  3. Replies: 7
    Last Post: 06-26-2007, 11:33 AM
  4. deleting rows screws formulas
    By wombat323 in forum Excel General
    Replies: 2
    Last Post: 11-11-2006, 07:58 PM
  5. Deleting hidden rows
    By Tobeman in forum Excel General
    Replies: 2
    Last Post: 10-27-2006, 05:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1