Hi All

Major noob warning!

I would like to use VBA to multiply by 10, a specified cell in the last updated row when a command button is pressed.

e.g.

When the command button is clicked - If row 30 is the last updated row, then the value in G30 must be multiplied by 10.

Hopefully this makes sense? The command button is to be on sheet 1 and the updated cell on sheet 2.

I'm very sorry if my explanation is not clear. I'd be very happy to provide more information if required?

Thanks in advance