| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP NEEDED FOR IF Function Inside a Macro
when using an IF then else function inside a macro, how do you reference a
cell for a specifc value in the IF function. Any help would be greatly appreciated. Thanks -- Sandi Gardner |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HELP NEEDED FOR IF Function Inside a Macro
Worksheets("Sheet1").Range("A1").Value
or Worksheets("Sheet1").Cells(1, 1).Value or if the cell is named Worksheets("Sheet1").Range("MyCellName").Value "Sandi" wrote: when using an IF then else function inside a macro, how do you reference a cell for a specifc value in the IF function. Any help would be greatly appreciated. Thanks -- Sandi Gardner |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to turn on "Track Changes" function | Excel Discussion (Misc queries) | |||
| Date & Time | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| Function Macro for Nested IF | Excel Worksheet Functions | |||
Linear Mode
