Linked cell

  • Thread starter Thread starter Raul Sousa
  • Start date Start date
R

Raul Sousa

Hi,
I have this code, which someone provided me.
(…)
NewWS.Cells(xx% + 1, 2).Value = Sheets(xx%).Range("c271").Value
(…)
My goal is to have in NewWS.Cells(xx% + 1, 2) a link instead of the value.
Any help is most welcome.
 
Raul,

NewWS.Cells(xx% + 1, 2).Formula = "='" & Sheets(xx%).Name & "'!C271"

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using a formula for a column vs. looping over each row - speed difference? 4
HOW TO SELECT SPECIFIED RANGE IN MACRO 4
the hard way 6
Copy data into sheets 13
Single line of code with line separator 4
Match and Extract Data 1
ActiveWorkbook.Names.Add Name ??? 4
Formula needed to SUM and COUNT in specific way 1

Back
Top