| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Magic" Formula
I have several cells on a worksheet that "magically" create a formula when I
enter data into the cell. I've deleted the contents of the cell, assigned a variety of formats, etc, to no avail. But, if I copy the contents of another cell and paste it into these cells things work just fine. Totally confused. Thanks in advance for help -- Bill Gable |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Magic" Formula
right click on the worksheet tabview code to see if there is a
worksheet_change event. -- Don Guillett SalesAid Software "Big Dog" wrote in message ... I have several cells on a worksheet that "magically" create a formula when I enter data into the cell. I've deleted the contents of the cell, assigned a variety of formats, etc, to no avail. But, if I copy the contents of another cell and paste it into these cells things work just fine. Totally confused. Thanks in advance for help -- Bill Gable |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Magic" Formula
Don:
WHile I am not familiar with you're suggestion, when I foolow your instructions I open a VB page that contains no code -- Bill Gable "Don Guillett" wrote: right click on the worksheet tabview code to see if there is a worksheet_change event. -- Don Guillett SalesAid Software "Big Dog" wrote in message ... I have several cells on a worksheet that "magically" create a formula when I enter data into the cell. I've deleted the contents of the cell, assigned a variety of formats, etc, to no avail. But, if I copy the contents of another cell and paste it into these cells things work just fine. Totally confused. Thanks in advance for help -- Bill Gable |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Magic" Formula
there isn't any code in the large right-hand panel either
-- Bill Gable "Don Guillett" wrote: OK. Now look in the ThisWorkbook module to see if there is code there that is doing it. -- Don Guillett SalesAid Software "Big Dog" wrote in message ... Don: WHile I am not familiar with you're suggestion, when I foolow your instructions I open a VB page that contains no code -- Bill Gable "Don Guillett" wrote: right click on the worksheet tabview code to see if there is a worksheet_change event. -- Don Guillett SalesAid Software "Big Dog" wrote in message ... I have several cells on a worksheet that "magically" create a formula when I enter data into the cell. I've deleted the contents of the cell, assigned a variety of formats, etc, to no avail. But, if I copy the contents of another cell and paste it into these cells things work just fine. Totally confused. Thanks in advance for help -- Bill Gable |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Magic" Formula
I will be going out shortly but send the workbook and I will take a look.
-- Don Guillett SalesAid Software "Big Dog" wrote in message ... there isn't any code in the large right-hand panel either -- Bill Gable "Don Guillett" wrote: OK. Now look in the ThisWorkbook module to see if there is code there that is doing it. -- Don Guillett SalesAid Software "Big Dog" wrote in message ... Don: WHile I am not familiar with you're suggestion, when I foolow your instructions I open a VB page that contains no code -- Bill Gable "Don Guillett" wrote: right click on the worksheet tabview code to see if there is a worksheet_change event. -- Don Guillett SalesAid Software "Big Dog" wrote in message ... I have several cells on a worksheet that "magically" create a formula when I enter data into the cell. I've deleted the contents of the cell, assigned a variety of formats, etc, to no avail. But, if I copy the contents of another cell and paste it into these cells things work just fine. Totally confused. Thanks in advance for help -- Bill Gable |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Magic" Formula
How about an example of what is entered in the cell, and what formula is
magically created. "Big Dog" wrote in message ... there isn't any code in the large right-hand panel either -- Bill Gable "Don Guillett" wrote: OK. Now look in the ThisWorkbook module to see if there is code there that is doing it. -- Don Guillett SalesAid Software "Big Dog" wrote in message ... Don: WHile I am not familiar with you're suggestion, when I foolow your instructions I open a VB page that contains no code -- Bill Gable "Don Guillett" wrote: right click on the worksheet tabview code to see if there is a worksheet_change event. -- Don Guillett SalesAid Software "Big Dog" wrote in message ... I have several cells on a worksheet that "magically" create a formula when I enter data into the cell. I've deleted the contents of the cell, assigned a variety of formats, etc, to no avail. But, if I copy the contents of another cell and paste it into these cells things work just fine. Totally confused. Thanks in advance for help -- Bill Gable |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
