MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cell Won't Hold Formula - Changes to a link


Posted by JohnH on July 06, 2001 1:30 PM

My spreadsheet has multiple macros one of which copies data from one worksheet to another and then off to another workbook.
One cell has the following:

=IF(Sheet2!$A$2="","DO NOT PROCEED","PROCEED BY CLICKING BUTTON BELOW")

Basically the logic is that if that A2 is blank do not copy range to the other workbook.

However, after the first instance when there are records available for transfer to the second workbook the formula in the cell changes automatically to the path of the second workbook at the end of the range. I can't seem to make the above formula stick.

Any ideas how I can keep this formula working?

Thanks.

John


Posted by Aladin Akyurek on July 06, 2001 3:20 PM

Did you try adding the workbook name (i.e. filename?

=IF([filename]...

Aladin

Posted by JohnH on July 07, 2001 7:06 AM


Yes, I have and it still doesn't solve the problem.

John : My spreadsheet has multiple macros one of which copies data from one worksheet to another and then off to another workbook. : One cell has the following:

Posted by JohnH on July 08, 2001 8:29 AM

Found Solution

Yes, I have and it still doesn't solve the problem. :

The answer is quite simple, instead of using the Cut and Paste method I used above, I used the Copy and Paste method to copy the data over and then coming back to the sheet and delete the records. This way the cut, which causes the link problem will not occur.