I am using the following piece of code below to populate values into A1, A2 and A3, but for some reason the first value of array gets repeated in cell A2 and A3.
Here is the code:
What I end up with is this:
A1 = Report Name:
A2 = Report Name:
A3 = Report Name:
but what I want is this:
A1 = Report Name:
A2 = Times Used:
A3 = Dates Used:
Here is the code:
Code:
With wksNewP
.Range("A1").Resize(3).Value = Array("Report Name:", "Times Used:", "Dates Used:")
End With
What I end up with is this:
A1 = Report Name:
A2 = Report Name:
A3 = Report Name:
but what I want is this:
A1 = Report Name:
A2 = Times Used:
A3 = Dates Used: