Hai I am maintaining a template which having values and blanks. I want to
delete the blank rows. I wrote program as
Sub DelRows()
Dim c As Range
strfind = InputBox("enter value to find and delete")
With Worksheets(1).Range("A:A")
Do
Set c = .Find(strfind, LookIn:=xlValues, lookat:=xlPart, _
MatchCase:=False)
If c Is Nothing Then Exit Do
c.EntireRow.Delete
Loop
End With
End Sub
Its working very fine. but the fact is i had locked certain cells and my
worksheet & workbook is password protected. the code above is not working for
this case. Please anyone help me to solve my problem
One way:
You can unprotect your worksheet in the macro, then protect it again:
Public Sub DelRows()
Const sPWORD As String = "drowssap"
Dim c As Range
Dim strfind As String
strfind = InputBox("enter value to find and delete")
With Worksheets(1)
.Unprotect Password:=sPWORD
With .Range("A:A")
Do
Set c = .Find( _
What:=strfind, _
LookIn:=xlValues, _
LookAt:=xlPart, _
MatchCase:=False)
If c Is Nothing Then Exit Do
c.EntireRow.Delete
Loop
End With
.Protect Password:=sPWORD
End With
End Sub
> Hai I am maintaining a template which having values and blanks. I want to
> delete the blank rows. I wrote program as
[quoted text clipped - 16 lines]
> worksheet & workbook is password protected. the code above is not working for
> this case. Please anyone help me to solve my problem
gane - 21 Nov 2007 05:58 GMT
thanks itz working great..........
> One way:
>
[quoted text clipped - 44 lines]
> > worksheet & workbook is password protected. the code above is not working for
> > this case. Please anyone help me to solve my problem