Sub DeleteEvent()
If Not
Application.Intersect(Range("A28,A32,A36,A40,A44,A48,A52,A56,A60,A64,A68,A72,A76,A80,A84,A88,A92,A96,A90"),
ActiveCell) Is Nothing Then
' ActiveCell.Resize(4).EntireRow.Delete
ActiveCell.Offset(-1, 0).Resize(4).EntireRow.Delete ' <======= Is
that want you meant Ron ??
End If
End Sub
Ithe code does not seem to do anything now??
Corey....
"Ron de Bruin" <(E-Mail Removed)> wrote in message
news:ekNbR8%(E-Mail Removed)...
> Hi Corey
>
> Change the cells in the range to the unlocked cells and use this in the
> code
>
> ActiveCell.Offset(-1, 0).Resize(4)
>
> With offset we go one row up before we resize
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Corey" <(E-Mail Removed)> wrote in message
> news:OGhWDy%(E-Mail Removed)...
>> ~~~~~~~~~~~
>> Sub DeleteEvent()
>> If Not
>> Application.Intersect(Range("A28,A32,A36,A40,A44,A48,A52,A56,A60,A64,A68,A72,A76,A80,A84,A88,A92,A96,A90"),
>> ActiveCell) Is Nothing Then
>> ActiveCell.Resize(4).EntireRow.Delete
>> End If
>> End Sub
>> ~~~~~~~~~~~
>>
>> The above code works great for my needs as it deletes the highlighted row
>> and the 3 rows below it also(4 in total).
>> But as i have now found once i protect the sheet i need to not allow that
>> row being selected anymore,
>> but instead i need the code to work if a cell is selected, rather than
>> the row. BUT the cell will be 1 row lower than the needed 1st row to be
>> deleted.
>>
>> EG.
>>
>> Previously i would highlight row 28, and when i click a commandbutton to
>> run the code,
>> rows 28-31(4 rows) would be deleted.
>> Now that the sheet is protected the user cannot select the row to
>> highlight the 1st row to be deleted.
>> I now need the cell A29 to be selected(which is not locked) then when the
>> user runs the code from the commandbutton,
>> the above row and the folowing 3 rows(4 in total) will be deleted.
>>
>>
>> The rows can be anywhere in the sheet from 28-240(in lots of 4 rows when
>> deleted)
>>
>> Can some help me to adjust this code to suit that?
>>
>> ctm
>>
>