Thread: Thorny Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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