Selecting a range based on cell references

  • Thread starter Thread starter Jonathan G.
  • Start date Start date
J

Jonathan G.

Probably very easy, but I have 2 cells which have the
values $A$1 abd $K$24 - the first cell is calcualated by
=CELL("address",A1) and the second ="$K"&"$"&VLOOKUP
("Last",M2:N50,2,FALSE)

what code in a macro do I use to select this range (i.e.,
from A1 to K24?
 
Hi
if X1 and Y1 store those values try
=range(range("X1").value & ":" & range("Y1").value).select
 
You must log in or register to reply here.

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

How to create a variable selected range 9
How to Select A Cell in VBA with a Variable Row Number? 3
I must make certain I have a specific range of numbers present. 3
conditional format based on column statistics and loop over columns 1
Referencing a cell value in a macro 7
Name Range Help 1
Creating a UDF to search a cell's formula 8
Selecting Range of Copied Text 2

Back
Top