My variable is equal to a cell link how can I insert the cell link into a cell

[albertocv]

NombreHojanPos ="$0$31" right now but it changes,
I want to paste =$0$31 into the cell d15 of my new sheet, so Whenever I change it on the original list, it will change here too.

I can't seem to manage to insert this cell reference. I know it must be something easy, but I am a beginner and completely self taught

This is what I have so far:

NombreHojanPos = Cells(lastrow + 1, 15).Address


'copiar Certificado

Sheets("Certificado").Select
Sheets("Certificado").Copy After:=Sheets(3)
ActiveSheet.Name = NombreHojan
Sheets(NombreHojan).Select
Range("d15").Select
Range("d15").Value = NombreHojanPos.Value

 

[JLGWhiz]

Unless NobreHojan is declared somewhere as a variable, you would need quotation marks around it as shown in this snippet.

ActiveSheet.Name = "NombreHojan"
 Sheets("NombreHojan").Select

then you need 'Range' in front of NombreHojanPos.Value since it equates to an address and not a range object.

Range("d15").Value = Range(NombreHojanPos).Value 'No quote marks here because it is a variable representing an address.

 

[MARK858]

I want to paste =$0$31

Really not sure I am reading this correctly but if not might get some clarification back...

 Sheets("Certificado").Copy After:=Sheets(3)
 ActiveSheet.Name = [COLOR="#FF0000"]"[/COLOR]NombreHojan[COLOR="#FF0000"]"[/COLOR]
 Sheets([COLOR="#FF0000"]"[/COLOR]NombreHojan[COLOR="#FF0000"]"[/COLOR]).Range("d15").Value = [COLOR="#FF0000"]"=" & NombreHojanPos[/COLOR]

 

[albertocv]

It worked perfectly, thank you. and you understood correctly