Auto adjusting range in VBA

[walt96]

Hi Everyone,

I am trying to create a code that adjusts to a changing range. In the second to last column I am trying to sort data (A to Z) that changes every time. In the last column I am creating group numbers based on the second to last column. The amount of rows and columns can change based on the data. Does anyone know what code I should use to adjust for dynamic rows and columns?

 

[igold]

Hi walt96,

Welcome to the Forum.

You have not given us very much to work with. That said, this is a very generic code that will return the Last Row with data in Column C and the Last Column with data in Row 4 on the active worksheet. There are many other ways to accomplish this, you may want to try a Google search to find other methods...

Sub test()


    Dim LastRow As Long
    Dim LastColumn As Long


    LastRow = Cells(Rows.Count, "C").End(xlUp).Row
    LastColumn = Cells(4, Columns.Count).End(xlToLeft).Column
    
    MsgBox "The last row with data in Column C is: " & LastRow & _
    vbNewLine & "The last column with data in Row 4 is: " & LastColumn


End Sub

I hope this helps.