Use memory variable in range selection

  • Thread starter Thread starter Ron5440
  • Start date Start date
R

Ron5440

My range always starts at B12 but it varies in depth.
After I find the bottom right I need to select to the top left
x = ActiveCell.Address
Range("b12":"x").Select
I did this a couple of years ago in another piece of code but cannot find an
example of it and don't remember how I did it.
I am still searching...if anyone has a quick piece of code it would be
appreciated.

Thnks,
Ron
 
This single line should do what you want...

Range(Range("B12"), ActiveCell).Select
 
My range always starts at B12 but it varies in depth.
Range("B12", Range("B12").End(xlDown)).Select
After I find the bottom right I need to select to the top left
Click to expand...
Range(Range("B12").Offset(, -1), Range("B12").End(xlDown)).Select

If this post helps click Yes
 
Ron,

One method is below. If you want to "smash" string data together, use
CONCATENATE, or & (see below).

Best,

Matthew Herbert

Range("B12",x).Select
Range("B12:" & x).Select
 
Try

Range("b12", ActiveCell).Select

If this post helps click Yes
 
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

File name extension 2
Clean this select case code up a bit. 2
Range to Variable for Sort 2
Select a range... 3
Variable Range, selecting/copying 1
Selecting Ranges using Variables 1
Passing variables in macros 2
VBA set thick borders around non empty cells in range 0

Back
Top