If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Activecell, not for cell,but for range?
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...o&userid=30147 View this thread: http://www.excelforum.com/showthread...hreadid=504515 |
#2
|
|||
|
|||
Activecell, not for cell,but for range?
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 "mturner" wrote in 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...o&userid=30147 | View this thread: http://www.excelforum.com/showthread...hreadid=504515 | |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Activecell problem | [email protected] | General Discussion | 1 | October 26th, 2005 02:13 PM |
ActiveCell giving blank value | itstome | New Users | 1 | August 30th, 2005 11:01 PM |
ActiveCell giving blank value in vbscript | itstome | Worksheet Functions | 1 | August 30th, 2005 04:24 PM |
Why ActiveCell in Excel call fails... | Paul | Using Forms | 0 | June 4th, 2005 07:51 AM |
Wrote a macro in visual basic editor, can't get it to repeat the action | iomighty | General Discussion | 5 | June 15th, 2004 12:25 AM |