Hi Excel Forum,
And a happy and prosperous 2021 to you all
You have to excuse the vague title but it was the best way I could explain it.
What I am trying to achieve is to name a range after part of a macro is run. I can do it with selection up but mother always tells me 'Never to select' in a macro as it is bad practice. So there must be a more efficient way which has now got me dumb founded.
I attach a very primitive spreadsheet with the macro in the back and you will see what I am trying to do but below is the code that I jotted up before this post
As you can see I have located the last cell in the specific column but what to do after that has blown my mind or maybe I am thinking to deep into it as surely it can't be that hard?
Any help would be greatly appreciated
Bookmarks