Range Question

[Turtleman10]

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?

Please Login or Register  to view this content.

[JosephP]

if you don't know what data type the cells will contain you can declare Part as variant

for part two you should use a named range instead of fixed cell addresses

[AB33]

Please Login or Register  to view this content.

[Turtleman10]

Well if it isnt my favorite moderator. Unfortuanately this is an existing spreadsheet that has been in use for years and the code needs to work with old saved versions so I cant name the range. I would love to it would make my life way more easy.

[Turtleman10]

AB33 I've got some questions. This code is a little further than I am. What is the (xlup) for? How dose it know when it reached the last cell?

[Turtleman10]

Ok I see the .end now so My only question would be the (xlup)

[AB33]

You could use as an option for LR

Please Login or Register  to view this content.

'This is will only look for used range.
(xlup) is going up from the last row up E9. You could also use (xldown) if you wish to go down from E9 to last row

[Turtleman10]

Thanks I love learning this stuff and it seems like there is so much to learn.

[AB33]

I am still learning and get better and better every day. Please close this thread.