troubleshooting Question

Delete Rows

Avatar of tonelm54
tonelm54 asked on
Microsoft Excel
1 Comment1 Solution34 ViewsLast Modified:
I need to delete rows from multiple sheets before I refresh the data, so I wrote the following:-
Sub refreshData()
    clearRange Sheets("All Incidents")
    clearRange Sheets("All Incidents 1")
    clearRange Sheets("All Incidents 2")
    clearRange Sheets("All Incidents 3")
    clearRange Sheets("All Incidents 4")
End Sub

Sub clearRange(targetSheet As Sheets)
    targetSheet.Rows("2:1000").Delete Shift:=xlUp
End Sub

But Im getting an error sayint targetSheet is not known. Any ideas how I can solve this issue?
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros