Creating a Static Cell Value Without vba

[sdruley]

03.28.2013-17.30.04 - sdruley's library

 

[Smitty]

Without VBA?

Copy-->Paste Special-->Values

 

[sdruley]

Thanks, Smitty,

I forgot to mention that this process has to happen unattended. Maybe a UDF or something. I don't know. The problem is I have 2400 of these. I just figured that there are so many ways to do something in excel that maybe someone has something automated to offer.

Steve

 

[Smitty]

A UDF is VBA though. Although they generally return results, rather than performing physical actions.

Why the reluctance to use VBA?

If you're not opposed to VBA you mentioned that you want this to happen after calculation, so I'd look at the Calculate event. Or if there is a manual input driving the calculation, then use a change event. The latter is a bit easier to control than the former, especially if you have a lot of calculations.

 

[sdruley]

Smitty,

Your followup is greatly appreciated. I found a way to solve my problem. I have inserted formulas in the cells in preparation for the calculation. Once the worksheet is calculated I remove the formula and leave just the value by using a worksheet calculation event.

Steve