VBA: Using target to fill cell in another worksheet (but first cell in current row)

[riggadoo]

Please help. I am using Excel 2010 and I have the following code which fills a cell in a different worksheet (CanMakeTool) with the contents of the currently selected cell. It works fine...

Sub HyperlinkCanMake()
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count = 1 Then Sheets("CanMakeTool").Cells(1, 1) = Target


End Sub

However I want the "target" to be the first cell in the (currently selected cell's) row. For example...

A:8 = "N123", I have cell H:8 selected which contains something else.
I want the contents of column A <of what="" ever="" row="" i="" select=""> to be inserted into the sheet "CanMakeTool" rather that the contents of my current selection - in this example "N123"

I hope this makes sense.</of>

 

[wigi]

Hi

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Count = 1 Then Sheets("CanMakeTool").Cells(1) = Range("A" & Target.Row).Value
End Sub

 

[riggadoo]

Wow. It works perfectly. Thank you very much! (answer in about 2 minutes)

 

[hartwog]

Reviving an old thread...

this code will work for me. except i need to show content from Columns A,B,C,D,E. Not just A of the selected cell.