View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Choosing Active Cell

I have a worksheet that contains 12 budgets (one for each month). Each
budget is identical in size (rows & columns). I have two commandbuttons that
allow me to sort two different ways. The user simply enters the month
(numeric value 1-12) and that particular budget is sorted.

What I am looking for is an automatic way to determine which budget is being
looked at, ie if I am viewing May's budget, logic would be I would be sorting
May's budget. I figure if I can determine what cell is currently selected,
then I can determine the range to be sorted automatically without the user
having to enter the month.

What code would determine what cell is selected?

Thanks,
Les