Excel Functions :-
Using Excel functions in VBA is almost the same as using them in a spreadsheet. For example to round an amount to 2 decimal places in a spreadsheet would be
=round(1.2345,2)
In VBA you would need to use the term Application followed by the function ie
ActiveCell = Application.round(ActiveCell, 2)
Using Excel functions in VBA is almost the same as using them in a spreadsheet. For example to round an amount to 2 decimal places in a spreadsheet would be
=round(1.2345,2)
In VBA you would need to use the term Application followed by the function ie
ActiveCell = Application.round(ActiveCell, 2)
No comments:
Post a Comment