View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Compile Error: Block If without End if

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