Paste method, defining the range

[bettingman]

Hi,

I am using the Paste method to paste data from the Clipboard into a range. It works fine when the range is defined like this:

Worksheets("Sheet2").Paste Worksheets("Sheet2").Range("C1:F100")

It results in an error however when I use the following code:

i = 4
Worksheets("Sheet2").Paste Worksheets("Sheet2").Range(Cells(1, i-1), Cells(100, i+2))

Any ideas why?

Thanks