Paul,
That worked great. Thanks!
Doug
Paul Schreiner wrote:
> The problem is that you're not telling
> VBA to use the VALUE of the variables,
> you're telling it to use the CHARACTERS
> in the NAME...
>
> what you need to do is "BUILD" the range like this:
>
>
>
> Range("C10:" & rCLR & ", D10:"
Paul,
Thank you! I will try that.
As I said, I tried a LOT of different ways to write it including:
Range("C10:" & rCLR , "D10:" & rDLR , "G10:" & rGLR).Select.
I knew that I had to build it as you suggested but I never thought the
"," would need to be inside the quotes.
On Sep 14, 2:20 pm,
The problem is that you're not telling
VBA to use the VALUE of the variables,
you're telling it to use the CHARACTERS
in the NAME...
what you need to do is "BUILD" the range like this:
Range("C10:" & rCLR & ", D10:" & rDLR & ", G10:" & rGLR).Select
that says to use the literal string "C10:" an