Activecell, not for cell,but for range?

  • Thread starter Thread starter mturner
  • Start date Start date
M

mturner

Is there a way of referring to an active selection of cells in vba, like
you can activecell for an individual cell?
 
You can use Selection when you know nothing else can be selected (like a
picture). Or ActiveWindow.RangeSelection which should always work (as long
as there is an active window).

--
Jim
message |
| Is there a way of referring to an active selection of cells in vba, like
| you can activecell for an individual cell?
|
|
| --
| mturner
| ------------------------------------------------------------------------
| mturner's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=30147
| View this thread: http://www.excelforum.com/showthread.php?threadid=504515
|
 

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

Excel Applying Code to a Column 0
Macro Flexability 7
Macro-active cell 3
ActiveCell on inactive sheet 8
SELECTION macro 1
VBA Question 8
Runtime Error '91' Object variable or With block variable not set 2
Can Vba workout if a selection is part of a group? 0

Back
Top