Creating a Static Cell Value Without vba

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

sdruley

Well-known Member
Joined
Oct 3, 2010
Messages
557
Office Version
  1. 365
Platform
  1. Windows
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

Legend
Joined
May 15, 2003
Messages
29,536
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

Well-known Member
Joined
Oct 3, 2010
Messages
557
Office Version
  1. 365
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,532
Messages
5,659,371
Members
418,499
Latest member
mbcmel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top