Stuck, find the last changed cell and use that cell in my macro.

[Luke1690]

Hi,

i have a workbook full of data, columns A2,I2

Colleagues go into the workbook find the row they need and edit it, in no particular order. When they edit the row i have a formula using (Concatenate) that creates a filename for them to use in column I.

I'm using a macro that creates this folder and sub folders this is all done so the names are consistent.

The trouble I'm having is, I have to use the code multiple times on every row to pick the correct file name.

i cant use last row either as the sheet is filled in randomly.

is there away to find last changed cell then have it show in (L1) so i can use the below



strName = (Sheets("sheet1").Range("l1").Value)


i cant share the sheet ill have to mock something up if needs be.

Thanks guys

 

[Anfinsen]

This code will run whenever a change is made in the specified worksheet, updating the lastChangedCell variable accordingly. You can modify this code to suit your specific requirements, such as logging the change in a separate location or performing additional actions based on the change.

Private Sub Worksheet_Change(ByVal Target As Range)
    ' Static variable to hold the address of the last changed cell
    Static lastChangedCell As String
    
    ' Update the address of the last changed cell
    lastChangedCell = Target.Address
End Sub