Thread
:
Deleting rows
View Single Post
#
3
Posted to microsoft.public.excel.programming
Jan Kronsell
external usenet poster
Posts: 99
Deleting rows
I figured it out myself, finally :-)
For h = ncn To 2 Step -1
If UCase(Cells(1, h).Value) = "X" Then
Cells(1, h).EntireColumn.Delete shift:=xlRight
End If
Next h
Does the trick.
Jan
Reply With Quote
Jan Kronsell
View Public Profile
Find all posts by Jan Kronsell