Thread: Dropbox choice runs macro Error ??

Okay! Nice , I think i was trying too hard , now my list on sheet 4 is clean, separated, and it works! I was able to get it to paste in cells a:15 to G:16(from sheet1) the only probleme is to get from A3 to E4 on sheet 4 , it copies the first column only . I see where it goes but when i try to change it the syntax never works! I can see the end of it and the understanding of this code, If i can just get this right ill be able to reproduce it and finish my project!

You could consider to use the help in the VBEditor and read what's written about currentregion.
It means that in sheet4 you have to fill column B, C and D to get the full currentregion; space will suffice.
The 'currentregion' is the most flexible approach.
An alternative could be:

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address = "$E$1" Then Sheets("sheet4").columns(1).find(target,,xlvalues,xlwhole).currentregion.offset(1).resize(,5).copy Sheets("sheet1").Range("A15") 
End Sub