S
Shane Devenshire
Hi,
I appologize if this has been covered, since I didn't read all the responses.
No macro necessary:
1. Enter 1000 in a blank cell and copy that cell
2. Select the range A4:A40, F4:F40 and choose Edit, Paste Special, Multiply
You can record that and it will run far faster than a loop.
I appologize if this has been covered, since I didn't read all the responses.
No macro necessary:
1. Enter 1000 in a blank cell and copy that cell
2. Select the range A4:A40, F4:F40 and choose Edit, Paste Special, Multiply
You can record that and it will run far faster than a loop.