Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.sendkeys shift+ctrl+enter
hi all,
does anyone know hoe to translate it for use for the function sendkey in excel? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.sendkeys shift+ctrl+enter
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 wrote in message ups.com... hi all, does anyone know hoe to translate it for use for the function sendkey in excel? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.sendkeys shift+ctrl+enter
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 wrote in message ups.com... hi all, does anyone know hoe to translate it for use for the function sendkey in excel? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.sendkeys shift+ctrl+enter
Here's a solution:
http://www.dailydoseofexcel.com/arch...rmulas-in-vba/ NickHK wrote in message ups.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 wrote in message ups.com... hi all, does anyone know hoe to translate it for use for the function sendkey in excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ctrl+shift+enter | Excel Worksheet Functions | |||
What is Ctrl + Shift + Enter ? | Excel Discussion (Misc queries) | |||
What does Ctrl+Shift+Enter do? How does it differ from Enter? | Excel Programming | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
ctrl/shift/enter thru VBA | Excel Programming |