How to get target cell value into another cell upon click

[jchamber00]

I think this should be pretty easy but cant get the syntax right. I am trying to get the value of a clicked cell into a static cell (D11).

I thought it would look something like this but its not working

Range("D11").Value = Target.Cells.Value

[Trebor76]

Hi jchamber00,

Try this:

Please Login or Register  to view this content.

HTH

Robert