Insert Concatenate Formula

[DARREN FONG via OfficeKB.com]

Hi!

I am trying to insert a concatenate formula for a https site

i.e =concatenate("https://websiteaddress,"A1",moreurldetail, "B1")

I think im looking for something like

ActiveCell.FormulaR1C1 = " =concatenate("https://websiteaddress",R[1]C[1],
"moreurldetail,"R[1]C[2]")"

Thanks in advance

 

[Amber_D_Laws]

What exactly are you trying to accomplish with the formula?
I ask, because as a beginner I have often thought I knew what I needed
and in the end it turned out I was completely wrong.
Whereas, I don't have an answer, maybe if one of the others that reall
*knows* what they are doing knows what your are trying to accomplis
they might be able to steer you better.

Just a thought. :

 

[DARREN FONG via OfficeKB.com]

Amber,

Im trying to open a single https page by hyperlinking in using the
concatenate funtion

 

[Dave Peterson]

Yeah, but...

Do you really want to see "B1" and "A1" in the results or do you want to see the
stuff in cells A1 and B1?

=concatenate("https://websiteaddress,"A1",moreurldetail, "B1")

=hyperlink("https://websiteaddress/" & $a$1 & "moreurldetail" & $b$1)

I'm guessing that you want what's in the cells:

ActiveCell.Formula _
= "=hyperlink(""https://websiteaddress/"" & $a$1 & ""moreurldetail"" & $b$1)"

(I like to use the & operator instead of the =concatenate() function. I find it
easier to read.)