VBA Range declaration

[bsquad]

I am wondering if someone could provide some insight;

I am having trouble getting over the concept of ranges -

why I am having trouble with

Range(Cells(4, 3), Cells(88, 12)).Copy

and no trouble with

Range ("C4:L88").Copy

I thought I may have read somewhere where it has to do with cell qualification, but still don't get it. It drives me insane to use hardcoded values / values in between " " . I realize I could declare the Range(Cells(),Cells()) as a Range, but will have multiple declarations then. I am trying to find an alternative solution to still be able to use the top format.

 

[mrhstn]

What trouble are you getting with...

Range(Cells(4, 3), Cells(88, 12)).Copy

it will copy the same as the range below.

 

[Fluff]

They should both do the same thing, as long as they are meant to work on the active sheet.
However if you are working on a non active they should be like this

With Sheets("Sheets1")
    .Range(.cells(4, 3), .cells(88, 12)).Copy
    .Range("C4:L88").Copy
End With