>>Try it.
>>It comes up as "$C$3". Numbers may be easier but how do you insert them into a .range statement?
>>
>>.range(.activecell.address + ":D4").select
>>
>>works for me.
>
>For a range statement, I use, for example: .Range(.Cells(lnRow1, lnCol1), .Cells(lnRow2, lnCol2))
>
>Still easier to work with numbers, for the cases where the range can vary.
>
>However, specifying the range this way is somewhat cumbersome; so I have created a method, in my reporting class, that returns an Excel range, when I pass the four parameters (specifying the upper-left and lower-right corner).
And .Cells is a component of what??