I have a Range E9:E17 that I would like to look at one cell at a time. I figured I would use this code to do that. My first question is how would I put the value of each of those cells into something like Part I have below without a mismatch?
Second Question how do I handle it if someone adds a row to the spreadsheet?
![]()
Sub test() Dim Part as string Dim rngCell As Range For Each rngCell In Range("e9:e17") 'what you want to do with the cell Next rngCell End Sub
Bookmarks