How to select range of cells

J

Jan Nademlejnsky

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Saving a range for later reference 0
Question about a range 9
Take active cell value in for loop and offset based on another cellvalue for columns to offset 0
Recorded macro selection widened 4
Macro Pause to Select range then Subtotal 0
Copy Array to Array, how to and should I? 13
Copying formulas across columns 2

Top