How to select range of cells

How to select range of cells

Post by Jan Nademl » Sat, 11 Dec 2004 09:50:03


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
 
 
 

How to select range of cells

Post by Jan Nademl » Sat, 11 Dec 2004 10:19:54

Sorry , I posted it to wrong group. It should go to Excel.

Jan