Posted to microsoft.public.excel.programming

JOUIOUI

external usenet poster

Posts: 72

Trouble with this code

I'm not sure what is wroing with this code, my goal is to clear any text in
Column E that does not match "HO". Any help is appreciated. Thanks

LastRow = Cells(Rows.Count, "E").End(xlUp).Row
For RowNdx = LastRow To 1 Step -1
If StrComp(Cells(RowNdx, "E"), "HO", vbTextCompare) Then
Rows(RowNdx)ActiveCell.ClearContents
End If
Next RowNdx

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
Trouble Adding VBA Code to Module; Bug in Excel/VBE?	Mat P:son	Excel Programming	4	April 20th 06 04:17 PM
Trouble Condensing Code	Ikaabod	Excel Programming	3	April 11th 06 09:53 PM
If than Else Trouble	Goofy	Excel Worksheet Functions	2	February 19th 06 10:48 AM
dim trouble	jocke	Excel Discussion (Misc queries)	7	October 6th 05 08:55 PM
Print dialog code trouble	Tim[_36_]	Excel Programming	1	April 18th 04 08:46 AM

All times are GMT +1. The time now is 08:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us