Problem Writing a Formula to a Cell using VBA

[StevenM]

See: 3smees23_v4.xlsm

Run: AddFloor

Where the rows are now red you should find the following:

At D29 & D44 you should see the formula =D14
And at C44 you should see the formula =C14

But ....

At B29 & B44 you should/will see "=B14" as text and not as a formula.
At C29 you should/will see "=C14" as text and not as a formula.

Open the VB editor and scroll down to:

Please Login or Register  to view this content.

This is the code I'm using to attempt to write formulas to these cells.

So the mystery is this, why did the above code correctly create formulas at D29, D44 & C44; but didn't at B29, B44, & C29?

I'm baffled and at wits end, what am I missing?

[JosephP]

the cells are formatted as Text. change that to something else before adding the formula. for example

Please Login or Register  to view this content.

[StevenM]

That worked!! Thanks! You're a Genius!!!!