| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF then GoTo
Ken Johnson wrote:
wrote: I have a summary sheet and one sheet for each month. I have formatted a cell, sheet1("Z1") to display only the month value and inserted =Today() in the formula bar for that cell. I am trying to use "IF" in a macro to goto the appropriate month Sheet based on the value of Sheet1 ("Z1"). Hi Richard, In VBA, with Today() in Sheet1!Z1... MonthName(Month(Sheet1.Range("Z1")),False) currently returns "November" MonthName(Month(Sheet1.Range("Z1")),True) currently returns "Nov" Does this help? Ken Johnson Hi Richard, Also, to use a macro to goto the appropriate worksheet, assuming the full month name is used on each sheet tab, ie November not Nov... Public Sub GotoMonthSheet() Worksheets(MonthName(Month(Sheet1.Range("z1")), False)).Activate End Sub will take you there. Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ? IF & GOTO ? | Excel Worksheet Functions | |||
| ? IF and GOTO ? | Excel Worksheet Functions | |||
| If.....Then GoTo....... | Excel Discussion (Misc queries) | |||
| On Error Goto doesn't goto | Excel Programming | |||
| On Error Goto doesn't goto | Excel Programming | |||
Threaded Mode
