| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked cell
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Linked cell
Raul,
NewWS.Cells(xx% + 1, 2).Formula = "='" & Sheets(xx%).Name & "'!C271" HTH, Bernie MS Excel MVP "Raul Sousa" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have a linked cell auto-size to fit the linked data? | Excel Discussion (Misc queries) | |||
| Using a cell reference to create linked info in another cell | Excel Discussion (Misc queries) | |||
| In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
| How to force a cell value to change if Linked cell moves? | Excel Discussion (Misc queries) | |||
| how do i record changing cell data (cell is dde linked) | Excel Discussion (Misc queries) | |||
Linear Mode
