Calculate individual cells in a column

[amyisleb]

Hi,

I need to calculate each of the individual cells in one column of my
worksheet. It is important that the I do not calculate the whole sheet
or workbook when I do this, just the individual cells. I know how to
do each cell individually (double clicking on the cell and pressing
return) but it is time intensive. How can I do it in a batch?

Thanks!

 

[JE McGimpsey]

Hi,

I need to calculate each of the individual cells in one column of my
worksheet. It is important that the I do not calculate the whole sheet
or workbook when I do this, just the individual cells. I know how to
do each cell individually (double clicking on the cell and pressing
return) but it is time intensive. How can I do it in a batch?

one way:

You can run this macro from the Tools/Macros/Macro menu, or you could
attach it to a button or keyboard shortcut. Adjust the column to suit:

Public Sub CalculateOneColumnOnly()
Range("A:A").Calculate
End Sub

Make sure Calculation is set to Manual.

If you're unfamiliar with macros:

Type Opt-F11 to enter the VB Editor. In the Project Browser window, you
should see your workbook highlighted (see

http://www.mcgimpsey.com/excel/modules.html

for a picture). Choose Insert/Module, and type or paste the above code
into the window that opens. Type Opt-F11 to return to XL.