View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Using Commandbutton for different ranges

I have a worksheet with 12 months of budgets. Across the top are
commandbuttons, one for each month, that I use to have that month brought
into view. I also have two commandbuttons per each month that perform a
sort.
FYI: One sort is to sort by due date and the other button sorts by
separating income entries and expenses.

I was wondering if there was anyway to just have two sort commandbuttons at
the top and somehow they would know which month was being view, thus know the
cell ranges to address for the sort?

Thanks,
Les