|OK, what cell do you want to name? The code needs to know that.|
BTW...just to make sure that we are on the same page, please review the following information and confirm that this is what you want to do. I don't want to do extra work that doesn't meet your requirements.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.