Home |
Search |
Today's Posts |
#13
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I prefer to think of myself more of the Jack Webb, er, Sgt. Joe Friday kind of
guy. That should annoy the young and the non-USA centric. Tom Ogilvy wrote: I've chastised him properly in that other thread <vbg. It's good to know the streets are safe again! We all owe you a debt of graditude. (faintly in the background: "Who was that masked man?" . . . "Why that was the Loooone Ranger" . . . ) -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... I've chastised him properly in that other thread <vbg. What's the difference between a multiposter and a catfish? One is a bottom feeder; the other is a fish. (or something like that with bosses/lawyers/etc....) Tom Ogilvy wrote: Say it ain't so; another bottom feeding multiposter? <g -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... See one more post at your thread in .misc. (Hi, Tom!) wrote: This is my first time using a Microsoft Excel Macro and I'm trying to run the following code and keep getting the: Compile Error: Block If without End if message and I can't figure out why Sub P() ' ' Macro1 Macro ' Changing FedEx Descriptions ' ' Keyboard Shortcut: Ctrl+Shift+X ' If Range("K2:K999").Select = "02" Then Range("M2:M999").Select = "FedEx Ground" Else If Range("K2:K999").Select = "03" Then Range("M2:M999").Select = "FedEx 2Day" Else If Range("K2:K999").Select = "" Then Range("M2:M999").Select = "" End If End Sub -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
Compile Error: Block If without End if | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
compile error: block if without end if | Excel Programming |