| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO?
All,
Is there anything obviously wrong with the below? Only it always runs applictaion three regardless of the value in A1. Sub CLEARall() If A1 = 1 Then Application.Run "One" ElseIf A1 = 2 Then Application.Run "Two" Else: A1 = 3 Application.Run "Three" End If Thanking-you, Neil |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MACRO?
Hi
Look at this code. Sub CLEARall() Range("A1").Value If Range("A1").Value= 1 Then Application.Run "One" ElseIf Range("A1").Value= 2 Then Application.Run "Two" ElseIf Range("A1").Value = 3 Then Application.Run "Three" End If End Sub Regards, Per "Neil Pearce" skrev i meddelelsen ... All, Is there anything obviously wrong with the below? Only it always runs applictaion three regardless of the value in A1. Sub CLEARall() If A1 = 1 Then Application.Run "One" ElseIf A1 = 2 Then Application.Run "Two" Else: A1 = 3 Application.Run "Three" End If Thanking-you, Neil |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MACRO?
Thanking-you kindly Per.
"Per Jessen" wrote: Hi Look at this code. Sub CLEARall() Range("A1").Value If Range("A1").Value= 1 Then Application.Run "One" ElseIf Range("A1").Value= 2 Then Application.Run "Two" ElseIf Range("A1").Value = 3 Then Application.Run "Three" End If End Sub Regards, Per "Neil Pearce" skrev i meddelelsen ... All, Is there anything obviously wrong with the below? Only it always runs applictaion three regardless of the value in A1. Sub CLEARall() If A1 = 1 Then Application.Run "One" ElseIf A1 = 2 Then Application.Run "Two" Else: A1 = 3 Application.Run "Three" End If Thanking-you, Neil |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MACRO?
Per,
The Code returns "invalid use of property" and stops at value on... Range("A1").Value Any ideas? Cheers, Neil "Per Jessen" wrote: Hi Look at this code. Sub CLEARall() Range("A1").Value If Range("A1").Value= 1 Then Application.Run "One" ElseIf Range("A1").Value= 2 Then Application.Run "Two" ElseIf Range("A1").Value = 3 Then Application.Run "Three" End If End Sub Regards, Per "Neil Pearce" skrev i meddelelsen ... All, Is there anything obviously wrong with the below? Only it always runs applictaion three regardless of the value in A1. Sub CLEARall() If A1 = 1 Then Application.Run "One" ElseIf A1 = 2 Then Application.Run "Two" Else: A1 = 3 Application.Run "Three" End If Thanking-you, Neil |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MACRO?
My fault,
I edited the code after I've pasted it to the news reader. Just remove the line mentioned, and it will be fine... regards, Per "Neil Pearce" skrev i meddelelsen ... Per, The Code returns "invalid use of property" and stops at value on... Range("A1").Value Any ideas? Cheers, Neil "Per Jessen" wrote: Hi Look at this code. Sub CLEARall() Range("A1").Value If Range("A1").Value= 1 Then Application.Run "One" ElseIf Range("A1").Value= 2 Then Application.Run "Two" ElseIf Range("A1").Value = 3 Then Application.Run "Three" End If End Sub Regards, Per "Neil Pearce" skrev i meddelelsen ... All, Is there anything obviously wrong with the below? Only it always runs applictaion three regardless of the value in A1. Sub CLEARall() If A1 = 1 Then Application.Run "One" ElseIf A1 = 2 Then Application.Run "Two" Else: A1 = 3 Application.Run "Three" End If Thanking-you, Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Linear Mode
