I need to write a macro which selects a range of cells based on given
variables.

Example:

A2 = 3 '(1st column to be selected)
B2 = 58 '(Last column to be selected)
C2 = 10 '(10 rows to be selected)
D2 = F3 '( Start Selection @ F3 )

A = Range ("A2")
B = Range ("B2")
C = Range ("C2")

How to replace this line with one containing the above variables to produce
this result:
Range ("F3:BJ58").select

I can deal with the numbers, but the column names are giving me problems

It should look something like this
Range ("F3"). Select
Range ("F" & A & ":???" & B - A).select

Thanks for your help

Jan

One way:

A = Range("A2").Value
B = Range("B2").Value
C = Range("C2").Value

Range(Range("D2").Value).Resize(C, B - A + 1).Select




In article ,
"Jan Nademlejnsky" wrote:

I need to write a macro which selects a range of cells based on given
variables.

Example:

A2 = 3 '(1st column to be selected)
B2 = 58 '(Last column to be selected)
C2 = 10 '(10 rows to be selected)
D2 = F3 '( Start Selection @ F3 )

A = Range ("A2")
B = Range ("B2")
C = Range ("C2")

How to replace this line with one containing the above variables to produce
this result:
Range ("F3:BJ58").select

I can deal with the numbers, but the column names are giving me problems

It should look something like this
Range ("F3"). Select
Range ("F" & A & ":???" & B - A).select

Thanks for your help

Jan

Thank you very much. This is exactly what I was after.

Jan

"JE McGimpsey" wrote in message
...
One way:

A = Range("A2").Value
B = Range("B2").Value
C = Range("C2").Value

Range(Range("D2").Value).Resize(C, B - A + 1).Select




In article ,
"Jan Nademlejnsky" wrote:

I need to write a macro which selects a range of cells based on given
variables.

Example:

A2 = 3 '(1st column to be selected)
B2 = 58 '(Last column to be selected)
C2 = 10 '(10 rows to be selected)
D2 = F3 '( Start Selection @ F3 )

A = Range ("A2")
B = Range ("B2")
C = Range ("C2")

How to replace this line with one containing the above variables to
produce
this result:
Range ("F3:BJ58").select

I can deal with the numbers, but the column names are giving me problems

It should look something like this
Range ("F3"). Select
Range ("F" & A & ":???" & B - A).select

Thanks for your help

Jan