Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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.? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to remove excel macros still there after normal delete? | Excel Discussion (Misc queries) | |||
I deleted all macros in Excel but still get dialog box | Excel Discussion (Misc queries) | |||
Are macros created in Excel 2003 compatible with Excel 5.0/95? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |