Copy & Paste Rows (One Sheet to Another) using a Subscript

[Bovey44]

I want to be able to copy a row of data from one sheet to another with a subscript rather than an absolute value.

Here's the example code that I'm using which brings an error:

Sheets("BASE (2)").Range("A(x):H(x)").Copy Destination:=Sheets("Sheet2").Range("A(z):H(z)")

I guess that I'm not using the subscripting properly - the values for x & z. What's the proper method for subscripting (indexing)?

Thank you.

 

[Fluff]

How about

Sheets("BASE (2)").Range("A" & x).Resize(, 8).Copy Destination:=Sheets("Sheet2").Range("A" & Z)