Thread: Insert Concatenate Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DARREN FONG via OfficeKB.com DARREN FONG via OfficeKB.com is offline
external usenet poster
  
Posts: 4
Default Insert Concatenate Formula
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1
Reply With QuoteReply With Quote