VBA Getting data from another Sheet

Asked Nov 05 '15 at 19:21

Active Nov 05 '15 at 19:21

Viewed 112 times

Currently i am trying to get data from another sheet, on the current sheet a user types dates they want to get. I am getting a syntax error though, when i try to get the data. This is my code.

Private Sub CommandButton1_Click()

Dim Fund As String, Start, EndD As Date


Fund = Range("B4")
Start = Range("B5")
EndD = Range("B6")
Dim rngS As Range
Dim rngE As Range

   Set rngS = Sheets("Sheet1").Range("A1:A10000").Find(Start, lookat:=xlPart)
    Set rngE = Sheets("Sheet1").Range("A1:A10000").Find(EndD, lookat:=xlPart)
      Sheets("Sheet1").Range("rngS.Address:rngE.Address").Copy Destination:=Sheets("mySheet01").Range("A8")



End Sub

edited Jul 09 '18 at 19:34

Community

asked Nov 05 '15 at 19:21

frankyyyyy

5

Remove the quotes from `Range("rngS.Address:rngE.Address")` and put this: `Range(rngS.Address & ":" & rngE.Address)` – Scott Craner Nov 05 '15 at 19:23
Thanks!! I was looking at it for a good 10 min, didn't realise that was all it needed – frankyyyyy Nov 05 '15 at 19:26

VBA Getting data from another Sheet

0 Answers0

Linked