Senin, 07 Desember 2015

[smf_addin] Digest Number 3575

4 Messages

Digest #3575
1a
1b
Re: changing an array by "Randy Harmelink" rharmelink
1c

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
>
>

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



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?


For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar