Hi all I have the following code in a module:
The worksheet this refers to is 'shEvents' but some of the cells starting at C3, E3 & L3 in that worksheet are referenced to in another worksheet called 'shSummary'. Could someone let me know if there is a way to adapt my code to also clear the contents of the cells in 'shSummary'?
Deleteing the row in the shSummary worksheet is not an option as some of the other columns relate to different worksheets.
Hopefully that makes sense on what I'm trying to accomplish.
Many thanks for any soultions or adice offered.
Paul
VBA Code:
Public Sub DeleteSelectedRow(ByVal row As Long)
shEvents.Range("A3").Offset(row).EntireRow.Delete
End Sub
The worksheet this refers to is 'shEvents' but some of the cells starting at C3, E3 & L3 in that worksheet are referenced to in another worksheet called 'shSummary'. Could someone let me know if there is a way to adapt my code to also clear the contents of the cells in 'shSummary'?
Deleteing the row in the shSummary worksheet is not an option as some of the other columns relate to different worksheets.
Hopefully that makes sense on what I'm trying to accomplish.
Many thanks for any soultions or adice offered.
Paul