Prev: Link checker: checking if a URL exists
Next: Debugging
From: Gord Dibben on 27 Mar 2010 11:15
Which returns 37984000

Not 100037984


Gord Dibben MS Excel MVP

On Fri, 26 Mar 2010 15:09:01 -0700, Shane Devenshire
<ShaneDevenshire(a)discussions.microsoft.com> wrote:

>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.
>
>--
>If this helps, please click the Yes button.
>
>Cheers,
>Shane Devenshire
>
>
>"MovingBeyondtheRecordButton" wrote:
>
>> How do I take the value from each cell defined in the range("A4:A40,F4:F40")
>> and place 1000 before the value and give this new number a name.
>>
>> Example:
>> Number in A4 is 37984
>> I want to use 100037984

First  |  Prev  | 
Pages: 1 2 3 4
Prev: Link checker: checking if a URL exists
Next: Debugging