Copying a Variable Range

[r2yneth]

Dim ffRow, ffCol As Integer
Set Master = Sheets("Master")

Master.Range(Cells(ffRow, ffCol + 3), Cells(ffRow, ffCol + 13)).Copy

The copy does not work and I cannot figure it out!

I have also tried

Master.Range(Range(ffRow, ffCol + 3), Range(ffRow, ffCol + 13)).Copy​

I am trying to copy the range D2:N2 using ffCol. Afterwards, it would be O2:Y2 using ffCol + 14 and ffCol + 25

Any help is greatly appreciated

 

[mumps]

Try:

Master.Range(Cells(ffRow, ffCol + 3), Cells(ffRow, ffCol + 13)).Copy

 

[r2yneth]

Try:

Master.Range(Cells(ffRow, ffCol + 3), Cells(ffRow, ffCol + 13)).Copy

Thanks for your reply, appreciate it Unfortunately that is the same thing I already have

 

[Fluff]

How about

Master.Range(Master.Cells(ffRow, ffCol + 3), Master.Cells(ffRow, ffCol + 13)).Copy

 

[mumps]

Try:

Master.Range(Master.Cells(ffRow, ffCol + 3), Master.Cells(ffRow, ffCol + 13)).Copy

 

[r2yneth]

How about

Master.Range(Master.Cells(ffRow, ffCol + 3), Master.Cells(ffRow, ffCol + 13)).Copy

​

Try:

Master.Range(Master.Cells(ffRow, ffCol + 3), Master.Cells(ffRow, ffCol + 13)).Copy

Thank you!!!!!! I would have never figured this out. Really, really, thank you!

 

[MARK858]

If Fluff's solution doesn't work for you how are you defining ffRow & ffCol?

 

[Fluff]

You're welcome & thanks for the feedback