Posted to microsoft.public.excel.programming

external usenet poster

Posts: 262

Trouble with Elseif command

Hello all...

trying to run the following simple program but it will not run. Have tried
the offline help and followed the example to the letter but with no luck.
Any ideas would be appreciated.

Sub ContractHighlight()
'
' ContractHighlight Macro
' Macro recorded 23/11/2004 by Keith Holden
'

'If h4 1 Then
Range("A4:M4").Select
Selection.Interior.ColorIndex = 3

ElseIf i4 1 Then
Range("A4:M4").Select
Selection.Interior.ColorIndex = 2

End If
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ELSEIF Loop to End	Robbie Doo	Excel Discussion (Misc queries)	0	January 13th 10 11:11 PM
Elseif?	ibrokit	Excel Worksheet Functions	5	November 25th 08 04:28 PM
if elseif	flow23	Excel Discussion (Misc queries)	0	November 14th 05 02:09 PM
ElseIf	tom1646	Excel Programming	4	October 19th 04 02:09 PM
If...Elseif...End If	javab98	Excel Programming	2	July 19th 04 07:23 PM

All times are GMT +1. The time now is 09:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us