Hello, I am Frank and I am trying to learn VBA by experimenting with macros and reading other code from other users. I am working with excel 2016. I have been racking my pea brain on this and I know it is something simple. Below is a macro that was working but not allowing me to select a start and end date from dates on spreadsheet. I have drop down boxes for start and end dates on spreadsheet.
Sub Macro1()
'
' Macro1 Macro
'
'
Range("D3:D5").Select "(This is where I want to be able to select my start and end dates) D3-startdate and D5-enddate"
Selection.Copy
Sheets("Reading").Select
Range("B1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Application.CutCopyMode = False
End Sub
I hope this explains what I am trying to do. Thank you in advance
Sub Macro1()
'
' Macro1 Macro
'
'
Range("D3:D5").Select "(This is where I want to be able to select my start and end dates) D3-startdate and D5-enddate"
Selection.Copy
Sheets("Reading").Select
Range("B1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Application.CutCopyMode = False
End Sub
I hope this explains what I am trying to do. Thank you in advance