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?