My formulas keep disappearing!

[gallagher]

Hi Everyone -

I'm completely new to this forum, and I'm about to hang myself ove
some analysis software I'm developing in Excel. Hope someone can hel
out!

I have a seemingly VERY simple problem, with no obvious solution. Her
it is...

On sheet1, I have a row of numbers, and at the end of the row, a cel
with the formula =ROUND(average($B$7:$CS$7),0).

When I click a command button on sheet2, visual basic runs the findfil
function, and when the selected file opens up, it copies the cells i
range($B$7:$CS$7), and paste the values of those cells into the sam
range of sheet1 of the original file.

So, basically, I'm replacing that row of numbers, and I want to see ho
the average of those numbers changes with different number sets. Ver
simple, right? So why on earth does the cell with the formula ge
replaced with the value of that formula when I paste new cells?

I'm probably making this sound more confusing than it should.
Essentially, when I paste values into the cells that my formula i
based on, the cell with the formula displays the value of the formula
but the formula itself disappears so that I can only use it once. No
only that, but if I try to then reenter the formula into that cell, i
won't remain a formula, but immediately converts it to the value.

Does anyone have a clue what's going on? Thanks all

 

[Frank Kabel]

Hi
could you post the relevant part of your code and specify the range of
your formulas exactly

 

[Myrna Larson]

So you are presumably pasting new data into B7:CS5, but the formula in (what
cell???) is converted to its value. Where is the cell with the formula. What
does your code look like.