>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).
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)