Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thorny Problem
Suppose I have 14 sheets. the first 5 information and
the rest (6-14) are available to filter and print. Suppose the user starts at 9 and selects the next 3 (9-12) No problem - I can capture the start sheet and increment the next 3. Suppose the user selects 9 and the previous 3 (9-6). Is there some mathmatical calc that I can perform that will tell me if he selected to the left or right and this ensure that he prints/filters the correct selection. Thanks, Glen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thorny Problem
Hi, Glen,
I assume this is realted to your last question and that you now know how many worksheets are selected but not which sheets. Perhaps this will help: Sub Tester() Dim SH As Worksheet For Each SH In ActiveWindow.SelectedSheets MsgBox SH.Name Next SH End Sub --- Regards, Norman wrote in message ... Suppose I have 14 sheets. the first 5 information and the rest (6-14) are available to filter and print. Suppose the user starts at 9 and selects the next 3 (9-12) No problem - I can capture the start sheet and increment the next 3. Suppose the user selects 9 and the previous 3 (9-6). Is there some mathmatical calc that I can perform that will tell me if he selected to the left or right and this ensure that he prints/filters the correct selection. Thanks, Glen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thorny Problem
Glen,
When you say that the user "selects sheets", do you mean she clicks on the sheet tabs and does a multiple sheet selection?? If so, the SelectedSheets property (e.g. ActiveWorkbook.Windows(1).SelectedSheets returns what you're looking for. Stan Scott New York City wrote in message ... Suppose I have 14 sheets. the first 5 information and the rest (6-14) are available to filter and print. Suppose the user starts at 9 and selects the next 3 (9-12) No problem - I can capture the start sheet and increment the next 3. Suppose the user selects 9 and the previous 3 (9-6). Is there some mathmatical calc that I can perform that will tell me if he selected to the left or right and this ensure that he prints/filters the correct selection. Thanks, Glen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Thorny problem graphing XAxis dates | Charts and Charting in Excel | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |