>>>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??
Of a sheet object, just like .Cells().
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)