Prev: Workbook Macro
Next: extracting data from one workbook to another
From: Peter T on 11 May 2010 11:08
Good catch!

Actually i = 8 to 255 does work (but not 256), eg

i = 8, formula: =PRODUCT(G110:IV110)
i = 255, formula: =PRODUCT(G110:I110)

however these are presumably not valid

Regards,
Peter T

"helene and gabor" <gabelene(a)townisp.com> wrote in message
news:45224148-AC73-4776-B4BC-FBD52D76A421(a)microsoft.com...
> Hello Peter,
>
> Tim gets the products of his entries given on line 110. His results is in
> H110.
> This limits the maximum i to : 7.
> If he wants to calculate products up to i=256 then the row of inputs would
> have to occupy 256 columns and the result to be entered into the 257th.
> column?
>
> Best Regards
>
> Gabor Sebo
> -----------------------------------------------------------------------------------------------------------------------------------------------------
>
> "Peter T" <peter_t(a)discussions> wrote in message
> news:ONbnm9A8KHA.3964(a)TK2MSFTNGP05.phx.gbl...
>> Ensure you have two sheets in the active workbook named "Input" and
>> "Aopen". Put a value between 1 to 256 Input!F2, run the code, then look
>> at Aopen!H110
>>
>> Regards,
>> Peter T
>>
>


First  |  Prev  | 
Pages: 1 2 3
Prev: Workbook Macro
Next: extracting data from one workbook to another