application.sendkeys shift+ctrl+enter

yaniv.dg@gmail.com · 07-17-2006, 08:40 AM

hi all,
does anyone know hoe to translate it for use for the function sendkey
in excel?

Chip Pearson · 07-17-2006, 09:35 AM

I would avoid SendKeys at all costs. If you need to array-enter a
formula from VBA, use the FormulaArray property. E.g.,

Range("A1").FormulaArray = "=SUM(B1:B10)"

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

<yaniv.dg@gmail.com> wrote in message
news:1153139722.545859.48500@p79g2000cwp.googlegroups.com...
> hi all,
> does anyone know hoe to translate it for use for the function
> sendkey
> in excel?
>

yaniv.dg@gmail.com · 07-18-2006, 02:55 AM

yes,i know but my problem is that the formulaarray doesnt accept more
the 255 characters and my formulaarray is passing thats why,im first
using usual formula and then call sendkey,this is how i can bypass this
problematic issue
Chip Pearson wrote:
> I would avoid SendKeys at all costs. If you need to array-enter a
> formula from VBA, use the FormulaArray property. E.g.,
>
> Range("A1").FormulaArray = "=SUM(B1:B10)"
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> <yaniv.dg@gmail.com> wrote in message
> news:1153139722.545859.48500@p79g2000cwp.googlegroups.com...
> > hi all,
> > does anyone know hoe to translate it for use for the function
> > sendkey
> > in excel?
> >

NickHK · 07-18-2006, 03:30 AM

Here's a solution:
http://www.dailydoseofexcel.com/arch...rmulas-in-vba/

NickHK

<yaniv.dg@gmail.com> wrote in message
news:1153205368.820335.82410@m73g2000cwd.googlegroups.com...
> yes,i know but my problem is that the formulaarray doesnt accept more
> the 255 characters and my formulaarray is passing thats why,im first
> using usual formula and then call sendkey,this is how i can bypass this
> problematic issue
> Chip Pearson wrote:
> > I would avoid SendKeys at all costs. If you need to array-enter a
> > formula from VBA, use the FormulaArray property. E.g.,
> >
> > Range("A1").FormulaArray = "=SUM(B1:B10)"
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
> >
> > <yaniv.dg@gmail.com> wrote in message
> > news:1153139722.545859.48500@p79g2000cwp.googlegroups.com...
> > > hi all,
> > > does anyone know hoe to translate it for use for the function
> > > sendkey
> > > in excel?
> > >
>

**linok** · 12-18-2014, 02:25 AM

Guys, I have used below function and it works perfect, however it takes a while to take effect(because of for loop)
<code lang="vb">
Function CreateArrayFunction(ByVal sRange As String, formula As String) As Boolean
For Each oCell In Worksheets("sheetName").Range(sRange)
oCell.FormulaArray = formula
Next oCell
End Function
</code>

does anyone knows alternative to this?

Thanks
-N

**:) Sixthsense :)** · 12-18-2014, 02:50 AM

Why you need a function for this??

You can assign it directly in your Macro code itself

Please Login or Register  to view this content.

**linok** · 12-18-2014, 03:04 AM

I tried 'FormulaArray' with 'Range' but this has 255 character limitation. This limitation is applicable to my function as well

Any clue on this?

I have tried solution given on http://dailydoseofexcel.com/archives...comment-694082
but this does not work for me.

**:) Sixthsense :)** · 12-18-2014, 03:53 AM

Hm... I mis-interpreted the question and apologies for that.

Sorry I don't have any suggestion for this

**Fotis1991** · 12-18-2014, 04:13 AM

linok

This is a 8 years old thread!! So pls take a look to forum rules, because:

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.