Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Worksheet saving of Ranges ...
Hi,
I am struggling to find out the way to get the selected range on all the worksheet of workbook when the workbook is opened using some APIs in VBA. What I mean is: 1. Create a new workbook say having three worksheets (Sheet1, Sheet2, Sheet3) 2. Goto Sheet1 and select range : A1: A10 3. Goto Sheet2 and select range : B1: B10 4. Goto Sheet3 and select range : C1: C10 5. Now Save and close the workbook. 6. Reopen the workbook 7. If I switch between the sheets I can see the selected range at the time of closing the workbook. 8. So if there a way by which I can get all these ranges when I open the workbook. Please help. Thanks and With Warm Regards, -Rahul Vakil -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Worksheet saving of Ranges ...
RV,
There is only one selection recognized by Excel and that is the selection in the active window. So you must activate each sheet and then read the selection address for that particular sheet. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "RV" wrote in message Hi, I am struggling to find out the way to get the selected range on all the worksheet of workbook when the workbook is opened using some APIs in VBA. What I mean is: 1. Create a new workbook say having three worksheets (Sheet1, Sheet2, Sheet3) 2. Goto Sheet1 and select range : A1: A10 3. Goto Sheet2 and select range : B1: B10 4. Goto Sheet3 and select range : C1: C10 5. Now Save and close the workbook. 6. Reopen the workbook 7. If I switch between the sheets I can see the selected range at the time of closing the workbook. 8. So if there a way by which I can get all these ranges when I open the workbook. Please help. Thanks and With Warm Regards, -Rahul Vakil -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic named ranges not saving | Excel Programming | |||
Saving ranges as GIFs | Excel Programming | |||
Saving Excel ranges as database tables | Excel Discussion (Misc queries) | |||
how do I name ranges in an Excel worksheet | Excel Worksheet Functions | |||
Saving files with names from ranges | Excel Programming |