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: 10
Default #REF in formula when delenting source

Hi.

I have done a macro that "uses" that creat PDF´s of a
workshseet (formated table). this formated table as is
source in another worksheet that as a 1000 record
database.

The problem is that, when i delete row 2 (so that the
valeu change in the "formated table") my links in the
other worksheet becomes #REF.

How stop #REF from appering?? i´ve tried manual
calculations baut i was no good....

Thanks´s a lot
SpeeD
 
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
Formula based on source = 30% ccKennedy Excel Discussion (Misc queries) 3 June 3rd 09 06:29 PM
How to reach at the source of the formula Ahmad[_2_] New Users to Excel 5 February 5th 09 05:01 PM
Changing Source Data in a Formula akimballsmith Excel Discussion (Misc queries) 2 September 16th 08 07:26 PM
Move source without altering formula barnabel Excel Discussion (Misc queries) 2 February 10th 07 02:01 PM
Travelling from a formula to its source denny Excel Discussion (Misc queries) 2 July 8th 05 06:57 AM


All times are GMT +1. The time now is 12:55 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"