I have the following code:
Range("A6").Value = ActiveSheet.Name
In row A5, I have the Name Column Header. If I were to insert a row in A4, then A6 becomes A7 and my code becomes ineffective.
I don't know what code to use but this is what I am thinking:
Dim Rng as Range
Set Rng = Range("A1:A50")
If cell.value = Rng then
Cell.offset(1,0).VALUE = Activesheet.name
End If
I know this code isn't going to work but I thought I would attempt to do it.
Thanks