How to find the last row with data within a range

[TAPS_MikeDion]

Hi all,
Looks like I'm getting worse with trying to figure out VBA as I get older. LOL

All I need to do is find the last row within the range W3:AH1000 and clear the contents. I understand that I could simply use that exact range, but I have numerous sheets to have this run through so speed can be crucial. The sheets all begin with these names "A-", "D-" and "T-", which are followed by the months of the year. For example: A-JAN, A-FEB, etc. The data in the range can be numeric, text, dates, if that matters.

Thank you to anyone offering assistance!!!

 

[Joe4]

For every row that has data, is there a certain column which is required (will always have data in it)?
It is much easier to locate the last row with data if we can pinpoint a single column to check.
We can still clear multiple columns, it is just easier to identify the row if we can limit our search to a specific column.

 

[kevin9999]

To find the last row with data in a specific range, you could use something like:

Option Explicit
Sub Last_Row_in_Range()
    Dim LRow As Long
    LRow = Range("W3:AH1000").Find("*", , xlFormulas, , xlByRows, xlPrevious).Row
End Sub

 

[Fuji]

I don't know if this make difference in speed than clearing whole range.

Sub test()
    Dim ws As Worksheet, LR&
    Application.ScreenUpdating = falae
    For Each ws In Worksheets
        If ws.Name Like "[ADT]-*" Then
            LR = ws.[max(if(w3:ah1000<>"",row(3:1000)))]
            If LR Then ws.Range("w3:ah" & LR).ClearContents
        End If
    Next
    Application.ScreenUpdating = True
End Sub

 

[TAPS_MikeDion]

Hi Joe,
Yes, column A would always have data. Correction, for all three (A, D, T) it would be column B.

Thank you Kevin & Fuji. I will try these out. I greatly appreciate the help!

 

[Joe4]

Hi Joe,
Yes, column A would always have data. Correction, for all three (A, D, T) it would be column B.

Thank you Kevin & Fuji. I will try these out. I greatly appreciate the help!

Hmmm, I don't see how that would be helpful, if you are trying trying to look at the range W3:AH1000.
None of those columns are actually in that range.

So I am kind of confused by your last statement...

 

[TAPS_MikeDion]

Hi Joe,
I'm sorry for the delay, but last week was crazy busy. I missed words in my response, which got you confused.

"Correction, for all three sets of sheets (A-, D-, T-) it would be column B."

 

[TAPS_MikeDion]

Thank you all. I was able to get Fuji's code to do everything I needed. I appreciate the help!