View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan Nademlejnsky Jan Nademlejnsky is offline
external usenet poster
 
Posts: 10
Default How to select range of cells

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