4 Messages
Digest #3575
Messages
Sun Dec 6, 2015 8:40 am (PST) . Posted by:
jimmymc00
Although I've been successful in the past at expanding an array to add more columns and rows I now seem to have forgotten how to do that. this is for the RCHGetYahooQuotes formula. Any help would be appreciated. Jim
Sun Dec 6, 2015 9:06 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Just highlight the new range (which must completely contain the old range),
hit F2 to edit the formula, make your changes, the Ctrl+Shift+Enter to
array-enter it over the new range.
On Sun, Dec 6, 2015 at 9:40 AM, jmcatee133@... wrote:
>
> Although I've been successful in the past at expanding an array to add
> more columns and rows I now seem to have forgotten how to do that. this is
> for the RCHGetYahooQuotes formula. Any help would be appreciated. Jim
>
>
hit F2 to edit the formula, make your changes, the Ctrl+Shift+Enter to
array-enter it over the new range.
On Sun, Dec 6, 2015 at 9:40 AM, jmcatee133@.
>
> Although I've been successful in the past at expanding an array to add
> more columns and rows I now seem to have forgotten how to do that. this is
> for the RCHGetYahooQuotes formula. Any help would be appreciated. Jim
>
>
Sun Dec 6, 2015 9:55 am (PST) . Posted by:
jimmymc00
Randy. Thanks for the confirmation and quick reply. After several attempts it finally dawned on me that maybe Excel was getting in the way. So, after closing and reopening Excel it worked fine. Seems that my Excel 13 was a bit more stable before Windows 10? Thanks again. Jim
-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Sun, Dec 6, 2015 12:06 pm
Subject: Re: [smf_addin] changing an array
Just highlight the new range (which must completely contain the old range), hit F2 to edit the formula, make your changes, the Ctrl+Shift+Enter to array-enter it over the new range.
On Sun, Dec 6, 2015 at 9:40 AM, jmcatee133@... wrote:
Although I've been successful in the past at expanding an array to add more columns and rows I now seem to have forgotten how to do that. this is for the RCHGetYahooQuotes formula. Any help would be appreciated. Jim
-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Sun, Dec 6, 2015 12:06 pm
Subject: Re: [smf_addin] changing an array
Just highlight the new range (which must completely contain the old range), hit F2 to edit the formula, make your changes, the Ctrl+Shift+Enter to array-enter it over the new range.
On Sun, Dec 6, 2015 at 9:40 AM, jmcatee133@.
Although I've been successful in the past at expanding an array to add more columns and rows I now seem to have forgotten how to do that. this is for the RCHGetYahooQuotes formula. Any help would be appreciated. Jim
Mon Dec 7, 2015 1:12 am (PST) . Posted by:
cgrauballe
Hi Guys
Is there any way to combine the use of morningstar and yahoo?
The thing is i use all the financial figures from morningstar, IS, BS, CF etc. But, i dont have the stock price development over the last 5 years from there so it creates problem when i put in my ticker, and it updates. Is there any way to overcome this problem?
Is there any way to combine the use of morningstar and yahoo?
The thing is i use all the financial figures from morningstar, IS, BS, CF etc. But, i dont have the stock price development over the last 5 years from there so it creates problem when i put in my ticker, and it updates. Is there any way to overcome this problem?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar