Dave, It works..thanks a lot
On Jul 15, 11:13 pm, Dave Bonallack wrote:
> Hi,
>
> You just need to find a unused cell near by, and use it as a recorder.
>
> If the unused cell is, say, E1, then your macro would look like this:
>
> Sub resetval_SCRUSH()
> Range("d1") = "0"
>
> Range("E1") = R
Hi,
You just need to find a unused cell near by, and use it as a recorder.
If the unused cell is, say, E1, then your macro would look like this:
Sub resetval_SCRUSH()
Range("d1") = "0"
Range("E1") = Range("E1") + 1
End Sub
You may need to start by putting 0 (zero) into E1, but try without
