Copying and pasting data into VBA

[Stclements1]

Below is a list of data that when installed into a trade sheet gives me a monthly trade sheet template if I add the same syntax as I have for Range A1 to all the other cells listed is it possible for me to then copy and paste all of it into VBA as a range A1:AA1 or do I need to input each cell value independently?

Range ("A1")
Value=Trade No

B1 Open Trades

C1 Closed Trades

D1 Open Trade Date

E1Close Trade Date

F1 Trade Period

G1Closed Fund Value

H1 Product

I1 Execution

J1 Trade Price

K1 Lots

L1 Trade Size

M1 Leverage

N1 Total Leverage

O1 % Margin

P1 £ Margin Required

Q1 Fund Balance

R1 % Target Return

S1 Target Exit Level

T1 Target Fund Return

U1 Actual Exit Level

V1 Interest on Open Position

W1 Actual Fund Return

X1 Nett Return after Interest

Y1 % Actual Return

Z1 Open Fund Value

AA1 % Fund Growth

 

[Fluff]

You could do it like

   Range("A1:AA1").Value = Array("Trade No", "Open Trades", "Closed Trades", "Open Trade Date", "Closed Trade Date")

 

[Stclements1]

Many thanks for that, great help.

 

[Fluff]

You're welcome & thanks for the feedback