I need to make a macro/write a VBA code to select from a range of cells,
say H8:AQ117, all cell values greater than 1, and then copy and paste them (paste Value only)
at the same location without their formula as I want those particular cells to
remain unaltered as I change the values at their source.
Could anyone help me with a code for this ?
I'm new to VBA and hence do not know how to code this.
say H8:AQ117, all cell values greater than 1, and then copy and paste them (paste Value only)
at the same location without their formula as I want those particular cells to
remain unaltered as I change the values at their source.
Could anyone help me with a code for this ?
I'm new to VBA and hence do not know how to code this.