1 New Message
Digest #2576
Message
Sun Apr 7, 2013 2:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Those have nothing to do with add-in functions. They are examples of how to
concatenate strings to cell references -- a normal EXCEL operation.
http://www.info-stat.com/XLConCat.htm
It might be easier if you try and create the URL outside of the add-in
function, so all you have to deal with is the concatenation. You know what
you want the URL to look like.
The ampersand is just the concatenation operator, just like + and - are
arithmetic operators.
On Sun, Apr 7, 2013 at 2:02 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> ah! i am not good in excel programming and is currently self-learning it
> myself.
>
> i get the logic behind the string. just a question is u have stated 3
> kinds of concatenate methods.
>
> ="....string1..." & A1 will link for example rchgettable to cell A1
> =A1 & "...string1..." will also for example rchgettable to cell A1 as well?
> ="....string1..." & A1 & "...string2..." will link theoretically link for
> example rchgettable to Cell A1 and link it to another rchgettable? which
> means it can link 2 tables at one go?
>
> or are all 3 concatenate methods are the same?
>
concatenate strings to cell references -- a normal EXCEL operation.
http://www.info-
It might be easier if you try and create the URL outside of the add-in
function, so all you have to deal with is the concatenation. You know what
you want the URL to look like.
The ampersand is just the concatenation operator, just like + and - are
arithmetic operators.
On Sun, Apr 7, 2013 at 2:02 AM, weekeewawa <weekeewawa@yahoo.
>
> ah! i am not good in excel programming and is currently self-learning it
> myself.
>
> i get the logic behind the string. just a question is u have stated 3
> kinds of concatenate methods.
>
> ="....string1.
> =A1 & "...string1.
> ="....string1.
> example rchgettable to Cell A1 and link it to another rchgettable? which
> means it can link 2 tables at one go?
>
> or are all 3 concatenate methods are the same?
>
Tidak ada komentar:
Posting Komentar