Worksheet copy doesn't copy formulas
Hi,
I have a worksheet I am copying which contains many formulas. When I copy the sheet, all of the formulas copy except 3. For these 3 cells, if there is a value, it copies the value only. If there is no value, it copies the formula. It must be some setting on the cells themselves as the others are fine. I have been unable to find it. The cells are formated General with no conditional formating. I have checked that the formulas are not hidden. Here is the code I use to copy the sheet. CAMMaster.Copy After:=Sheets(ShNumber) Does anyone have any suggestions as to what this might be? Thanks for your help. -- Karen |
Worksheet copy doesn't copy formulas
what is the formula that converts to a value when copied?
On Oct 4, 12:23 pm, Karen53 wrote: Hi, I have a worksheet I am copying which contains many formulas. When I copy the sheet, all of the formulas copy except 3. For these 3 cells, if there is a value, it copies the value only. If there is no value, it copies the formula. It must be some setting on the cells themselves as the others are fine. I have been unable to find it. The cells are formated General with no conditional formating. I have checked that the formulas are not hidden. Here is the code I use to copy the sheet. CAMMaster.Copy After:=Sheets(ShNumber) Does anyone have any suggestions as to what this might be? Thanks for your help. -- Karen |
Worksheet copy doesn't copy formulas
Karen53, Please provide the formula that is in each of the 3 cells. "Karen53" wrote: Hi, I have a worksheet I am copying which contains many formulas. When I copy the sheet, all of the formulas copy except 3. For these 3 cells, if there is a value, it copies the value only. If there is no value, it copies the formula. It must be some setting on the cells themselves as the others are fine. I have been unable to find it. The cells are formated General with no conditional formating. I have checked that the formulas are not hidden. Here is the code I use to copy the sheet. CAMMaster.Copy After:=Sheets(ShNumber) Does anyone have any suggestions as to what this might be? Thanks for your help. -- Karen |
Worksheet copy doesn't copy formulas
Hi,
I tried everything. I saved the workbook, closed the workbook, reopened the workbook but these 3 formulas would not copy. I did a 'save as' on the workbook and the formulas started copying. It's a moot point now but here are the formulas: =IF(ISBLANK(INDEX(CAMPoolTypes,10,1)),"","Tenant Sq Ft") =IF(ISBLANK(INDEX(CAMPoolTypes,10,1)),"","Denomina tor") =IF(ISBLANK(INDEX(CAMPoolTypes,10,1)),"","Pro-rata Share") What would make it do that? I have almost identical formulas elsewhere on the sheet which copied with no problem. =IF(ISBLANK(INDEX(TaxPoolTypes,10,1)),"","Tenant Sq Ft") Thanks for your help -- Karen "JRForm" wrote: Karen53, Please provide the formula that is in each of the 3 cells. "Karen53" wrote: Hi, I have a worksheet I am copying which contains many formulas. When I copy the sheet, all of the formulas copy except 3. For these 3 cells, if there is a value, it copies the value only. If there is no value, it copies the formula. It must be some setting on the cells themselves as the others are fine. I have been unable to find it. The cells are formated General with no conditional formating. I have checked that the formulas are not hidden. Here is the code I use to copy the sheet. CAMMaster.Copy After:=Sheets(ShNumber) Does anyone have any suggestions as to what this might be? Thanks for your help. -- Karen |
All times are GMT +1. The time now is 11:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com