Excel VBA select range at last row and column

Question

I m trying to create a macro that selects the range of last row and last column   E g  I want to select 1  2  3  4 from my spreadsheet and then delete the selection   Data   John    10   10   10 Smith   5    5    5 Fred    8    8    8  1       2    3    4   Here is my code  it only selects the the last row on the A column   selects 1 and deletes it   I need it to select 1 to 4 and delete the whole row     Range  A   amp  Rows Count  End xlUp  Select Selection Delete Shift  xlUp

User · Answer

The simplest modification  to the code in your question  is this       Range  A   amp  Rows Count  End xlUp  Select     Selection EntireRow Delete   Which can be simplified to       Range  A   amp  Rows Count  End xlUp  EntireRow Delete

User · Answer

Another simple way   ActiveSheet Rows ActiveSheet UsedRange Rows Count 1  Select     Selection EntireRow Delete   or simpler   ActiveSheet Rows ActiveSheet UsedRange Rows Count 1  EntireRow Delete

User · Answer

Is this what you are trying  I have commented the code so that you will not have any problem understanding it   Sub Sample       Dim ws As Worksheet     Dim lRow As Long  lCol As Long     Dim rng As Range          gt  Set this to the relevant worksheet     Set ws    Sheet1       With ws             gt  Get the last row and last column         lRow    Range  A   amp   Rows Count  End xlUp  Row         lCol    Cells 1   Columns Count  End xlToLeft  Column              gt  Set the range         Set rng    Range  Cells lRow  1    Cells lRow  lCol            With rng             Debug Print  Address                               gt  What ever you want to do with the address                       End With     End With End Sub   BTW I am assuming that LastRow is the same for all rows and same goes for the columns  If that is not the case then you will have use  Find to find the Last Row and the Last Column  You might want to see THIS

[excel] Excel VBA select range at last row and column

Examples related to excel

Examples related to vba