Prime Number just for fun

When I hold down the ENTER key, the cursor takes off down the sheet.
Would there be a way of placing this in a module and coding it?
Thanks,
Paul
===========

"daddylonglegs" <[email protected]>
wrote in message
news:[email protected]...
>
> Used as a cell formula it needs to be confirmed with CTRL+SHIFT+ENTER so
> that braces like these { } appear around the formula in the formula
> bar.
>
> If you already have the formula in B1 then simply put the cursor
> somewhere in the formula within the formula bar and hit CTRL+SHIFT
> while holding down ENTER....
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile:
> http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=521585
>

you can try this, just change b2 to wherever you want the formula

Range("b2").FormulaArray = _
"=OR(A1=2,A1=3,ISNA(MATCH(TRUE,A1/ROW(INDIRECT(""2:"" & INT(SQRT(A1))))" _
& "=INT(A1/ROW(INDIRECT(""2:"" & INT(SQRT(A1))))),0)))"

--


Gary


"Paul Breslin" <[email protected]> wrote in message
news:[email protected]...
> When I hold down the ENTER key, the cursor takes off down the sheet.
> Would there be a way of placing this in a module and coding it?
> Thanks,
> Paul
> ===========
>
> "daddylonglegs" <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> Used as a cell formula it needs to be confirmed with CTRL+SHIFT+ENTER so
>> that braces like these { } appear around the formula in the formula
>> bar.
>>
>> If you already have the formula in B1 then simply put the cursor
>> somewhere in the formula within the formula bar and hit CTRL+SHIFT
>> while holding down ENTER....
>>
>>
>> --
>> daddylonglegs
>> ------------------------------------------------------------------------
>> daddylonglegs's Profile:
>> http://www.excelforum.com/member.php...o&userid=30486
>> View this thread: http://www.excelforum.com/showthread...hreadid=521585
>>
>
>

Thanks very much - that worked just fine.
Paul
------------


"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:[email protected]...
> you can try this, just change b2 to wherever you want the formula
>
> Range("b2").FormulaArray = _
> "=OR(A1=2,A1=3,ISNA(MATCH(TRUE,A1/ROW(INDIRECT(""2:"" &
> INT(SQRT(A1))))" _
> & "=INT(A1/ROW(INDIRECT(""2:"" & INT(SQRT(A1))))),0)))"
>
> --
>
>
> Gary
>
>
> "Paul Breslin" <[email protected]> wrote in message
> news:[email protected]...
>> When I hold down the ENTER key, the cursor takes off down the sheet.
>> Would there be a way of placing this in a module and coding it?
>> Thanks,
>> Paul
>> ===========
>>
>> "daddylonglegs"
>> <[email protected]> wrote in
>> message
>> news:[email protected]...
>>>
>>> Used as a cell formula it needs to be confirmed with CTRL+SHIFT+ENTER so
>>> that braces like these { } appear around the formula in the formula
>>> bar.
>>>
>>> If you already have the formula in B1 then simply put the cursor
>>> somewhere in the formula within the formula bar and hit CTRL+SHIFT
>>> while holding down ENTER....
>>>
>>>
>>> --
>>> daddylonglegs
>>> ------------------------------------------------------------------------
>>> daddylonglegs's Profile:
>>> http://www.excelforum.com/member.php...o&userid=30486
>>> View this thread:
>>> http://www.excelforum.com/showthread...hreadid=521585
>>>
>>
>>
>
>

Sorry guys, just all fingers and thumbs

of course Tom's right......write out 100 times....

I would hold down the Ctrl+Shift Keys and hit the Enter key
I would hold down the Ctrl+Shift Keys and hit the Enter key
I would hold down the Ctrl+Shift Keys and hit the Enter key
I would hold down the Ctrl+Shift Keys and hit the Enter key
I would hold down the Ctrl+Shift Keys and hit the Enter key
I would hold down the ......