VBA object to copy a row when that row is clicked...

[seandotson]

I have a sheet where I have a series of columns with info. I need the ability to click on a button or object in that row and copy that row (technically a range of that row) to the clipboard.

This could easily be solved with VB object control arrays but those do not exist in VBA.

Any suggestions on how to make this work...(I have the code to make the button copy, need help with the object to use to trigger the code)

A visual example: http://i.imgur.com/3BanpHS.png

 

[sijpie]

If you are pasting into another instance of Excel, then Excel refuses to take the formulas across. If it is in the same instance then it should work.

But my question will be: if you are pasting from one workbook to another:

1. why are you not using: range1.copy destination:=range2 instead of putting it to the clipboard?
2. why would you paste it into another instance of Excel?

 

[Jaafar Tribak]

I have just reread your question and I think we forgot something that would avoid us the need to write tons of code .. Just set the Cancel Argument to true and this will probably solve your problem :

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Dim CopyData As Range
    On Error Resume Next
    
   [B] Cancel = True[/B]
    Set CopyData = Range("C" & Target.Row & ":W" & Target.Row)
    CopyData.Copy

End Sub