Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I've got a weird one here folks. I have a simple workbook that

keeps track of certain files on the computer by recording the

location of the file, and the date and time the file was last

modified. I have a VBA function in a cell that determines the

correct modification date of the file by using the data in 2 other

cells (PATH and FILENAME) respectively. Works great in the original

column. Yet, when I try to copy the working cell from one column to

another, the results of the formula(function) do not appear in the

target cell. The formula appears, but it will not calculate and

display the result. I've tried many things to fix this:

1. recalculate all formulas

2. check to ensure that target column/cell is not locked

3. save workbook, close and reopen

4. type formula with VBA and source cell references by hand

5. I forget what else.

Using Excel in Office 2003. Any ideas?

Could you post the code for your function so we could try to help?

Please consider this issue as resolved. I spoke with Microsoft tech

support. They indicated the reason the target columns would not

display the results of the formula was due to the format of the

cells in the column being Text instead of General. To fix this, I

had to:

1. copy the formula from the source cell/column to the target

cell/column

2. select the target cell column, change format to General

3. select the text of the formula in the cell and press F2 then

Enter

The results of the formula then appeared as expected. I've worked

with excel since 1999, have done extensive formula and VBA work and

have never seen this before. I was unable to find any reference to

behavior of this kind on the 'net.

Didn't find what you were looking for?
Find more on cells containing formula that refer to user-defined VBA function
Or get search suggestion and latest updates.

Related Topics:

- VBA code to add values in two cells which have formulas
- Copy Value produced by formula in cell C3 to cell D3
- to see if text in a cell in a column is contained in any cell
- Copy cell contents to same cell on different worksheet if contains
- User defined functions not recognized
- user defined functions
- User Defined Function didn't work
- User Defined Functions
- Function needed to split the content of a cell intomany cells
- Function needed to split the content of a cell into many cells
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- Run-Time Error 9 - Trying to refer to cells in worksheet
- Help to refer a cell
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- formula returns to multiple cells, without Array object?
- Using an array formula as a hyperlink cell reference
- VBA Formula prob
- Getting a formula to copy from inside VBA
- Formula using range name in VBA code
- VBA or array formula?
- formula help but not vba please
- Copy down formula with vba
- VBA Code for pasting a set of formulas down a data range
- VBA variable range in a formula
- Populate Formula(Function) in rows