selecting a range with two variables

[Josh_123456]

Can someone please show me how to select a range with two variables

x and y

i know how to do

Please Login or Register  to view this content.

but how do i do the following

Please Login or Register  to view this content.

, using x and y instead of 1 and 500


thanks

Josh

[royUK]

What exactly are you doing? What is determining X & Y?
You don't usually need to select a range in VBA

[Leith Ross]

Hello Josh,

Here are a couple of ways to use variables in a range address. It is important to remember that the row variable needs to be declared as a Long type. The column variable can be declared as a Variant type, since it can take a string or long data type.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Josh_123456]

that worked great


Josh