View Single Post
  #2   Report Post  
David of XL Plus David of XL Plus is offline
Junior Member
 
Posts: 19
Default

Quote:
Originally Posted by Pavlov Bell View Post
Hi,

I am trying to set a macro to do the following: insert the formula in the active cell (or in each cells selected). Formula: "=round( 'activecell value' ;0)"

The activecell could have a number like: 5,68 or a formula: A1+A2.

Can someone help!

Thanks a lot.
Hi,

Best way to begin is to use the Macro Recorder.

Then edit that code as necessary.

David