[Solved] VBA: syntax for range.select using variable

[marcusb]

My code is below.

I have used
Range("I"&Row1).Select
now I want to select a range from ("I"&Row1) to ("P"&Row1)

but i can't get the syntax right. can anyone help.

>>>>>>>

Row1 = Worksheets("UMBRELLA FORM").Range("AF96")

Sheets("UMBRELLA FORM").Select
Range("U96:AD96").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Expenses").Select
Range("I:P" & Row1).Select
ActiveSheet.Paste
Application.CutCopyMode = False

[marcusb]

i'm an idiot

[Epidemic]

Just for giggles I am partial to using
cells function

Cells(1,1)

range(cells(1,1),cells(10,1))

Variables can replace any of the numbers