Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choosing Active Cell
Sub whereami()
MsgBox (ActiveCell.Address) MsgBox (ActiveSheet.Name) End Sub -- Gary''s Student - gsnu200788 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choosing Active Cell
Hi Les,
Dim Rng As Range Set Rng = ActiveCelll MsgBox Rng.Address(External:=True) --- Regards. Norman "WLMPilot" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choosing Active Cell
Hi Les,
Slightly over enthusiastic typing: Set Rng = ActiveCelll should be: Set Rng = ActiveCell --- Regards. Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Test if moving off a cell without choosing a value | Excel Programming | |||
choosing a cell from a range | Excel Discussion (Misc queries) | |||
choosing the a cell from a range | Excel Discussion (Misc queries) | |||
choosing a cell with a comment | Excel Discussion (Misc queries) | |||
Choosing from 2 formulas for one cell | Excel Programming |