Choosing Active Cell

[WLMPilot]

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

 

[Gary''s Student]

Sub whereami()
MsgBox (ActiveCell.Address)
MsgBox (ActiveSheet.Name)
End Sub

 

[Norman Jones]

Hi Les,

Dim Rng As Range

Set Rng = ActiveCelll

MsgBox Rng.Address(External:=True)

 

[Norman Jones]

Hi Les,

Slightly over enthusiastic typing:

Set Rng = ActiveCelll

should be:

Set Rng = ActiveCell

 

[WLMPilot]

Thanks.

Les

 

[WLMPilot]

Thanks.

Les

Hi Les,

Slightly over enthusiastic typing:



should be:

Set Rng = ActiveCell