| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Program to make cell a formula
Thanks, Lonnie!
"Lonnie M." wrote in message oups.com... Hi Craig, if I understand your question, the following modification to your code should work: Sub RoundAdd2() Dim myStr As String Dim Cel As Range For Each Cel In Selection Cel.Value = Application.WorksheetFunction.Round(Cel.Value, -2) Next End Sub HTH--Lonnie M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel GURUs help. (How to make program parse more than 1 forumla within a cell) | Excel Worksheet Functions | |||
| Make a Workbook into VB Program | Excel Programming | |||
| make my vba/excel program faster | Excel Programming | |||
| make my vba/excel program faster | Excel Programming | |||
| make my VBA program faster | Excel Programming | |||
Hybrid Mode
