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
|
|||
|
|||
Excel Macros
How can i setup a range macro were if the user dumps 10 cells worth of data
it will select jsut those 10 cells however if the user dumps 20 cells it will adjust the range to select all 20 cells.? |
#2
|
|||
|
|||
Excel Macros
ACtivecell.CurrentRegion.Select
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "LMI" wrote in message ... How can i setup a range macro were if the user dumps 10 cells worth of data it will select jsut those 10 cells however if the user dumps 20 cells it will adjust the range to select all 20 cells.? |
Thread Tools | |
Display Modes | |
|
|