New to Excel Macros

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

I'm converting some Quatro Pro spreadsheets to Excel and am having problems
figuring out some of the requirements for Excel macros.

Here is an example. It converts several cells across columns from calculated
figures to numbers. As you can see it really is simple and repetitive, but
I'm stuck.

Thanks in advance, Terry

Macro to change formulas to values
after making allotment input
\C {edit}{calc}~
{right}
{edit}{calc}~
{right}
{edit}{calc}~
{right}
{edit}{calc}~
{right}
{edit}{calc}~
{right}
{edit}{calc}~
{right}
{edit}{calc}~
{right}
{edit}{calc}~
{right}
{edit}{calc}~
{right}
{edit}{calc}~
{right}
{edit}{calc}~
 
One way:

This converts selected cells to their values:

Public Sub MakeValues()
With Selection
.Value = .Value
End With
End Sub

Which is equivalent to

Public Sub MakeValues()
Selection.Value = Selection.Value
End Sub
 
Back
Top