Put text of cell into cell selection

[njd123]

So basically, in cell G1 is the text "D4". When I press a command button I want it to take the value in cell G1 - ("D4") - and then in cell D4 enter the value 10.
The code I tried is:
Range(Range("G1").value).value = "10"
However this does not work. Can anyone help me please?

[marreco]

Maybe I do not understand, try this.

Range("G1").Value= "10"

[njd123]

That is not what I quite want I was just trying to make the question simpler by using a shorter example. I want to select the cell which is written in G1 and in this want to paste a value.

[DonkeyOte]

Your suggest code line of:

Please Login or Register  to view this content.

should work -- when you say it does not can you elaborate (error message or unintended result?) - where is the code located VBE wise ?

[njd123]

Aha! I have found the problem. My full line of code was:

Please Login or Register  to view this content.

but now have realized that it had to be:

Please Login or Register  to view this content.

I am sorry to have wasted your time but thank you very much anyway for your help.

[DonkeyOte]

Remembering to qualify can be a pain !

You might find it easier to use With statements ?

Please Login or Register  to view this content.

[njd123]

Ok thanks a lot will look into it.