EXCEL FEED: Re: [smf_addin] Entire Table (=RCHGetHTMLTable)

Jumat, 20 Maret 2020

Re: [smf_addin] Entire Table (=RCHGetHTMLTable)

#VALUE! usually means the passed parameters isn't the correct type. For example, passing a number when a string is required.

Not sure what issues might exist because of a Mac.

On Thu, Mar 19, 2020 at 11:09 PM Mic Peg mic_peg@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

I get an error "#VALUE!". I don't understand spill but I selected an array range and applied the formula returning an error.

On Thursday, March 19, 2020, 3:29:43 PM GMT+8, Randy Harmelink rharmelink@... wrote:

Define "not worked". What result did you get? Did you spill, or array-enter over a range, or try both?

I know next to nothing about Macs.

On Thu, Mar 19, 2020 at 12:16 AM Mic Peg mic_peg@... wrote:

Thanks. Both lines has not worked for me. Perhaps my excel is Excel Mac 2011, Version 14.
In this case, is there any alternative lines for this version?

On Thursday, March 19, 2020, 2:35:59 AM GMT+8, Randy Harmelink ... wrote:

There are multiple tables on each page. If your version of EXCEL has the new spill feature, just enter each of these into a cell (where there is enough room for them to spill out):

=RCHGetHTMLTable("https://tradingeconomics.com/stocks","",1,"",14,,130,9)

=RCHGetHTMLTable("https://tradingeconomics.com/currencies","",1,"",5,,100,9)

Otherwise, array-enter each over a range.