Newb simple macro coding question

Hi folks,
I've just found this site and used to program Excel Functions & Macro's years ago and now find myself coming back to something a tad different.
I'm in the process of finding some refresher info on here (guidance appreciated) through the searches but have an immediate problem to fix and hope you can help.
My problem is formatting syntax and understanding how the structure has changed. The following [a cut-down version] fails because of that, could you help get me back on the road please...
Many thanks
Steve

I've been doing more research and I think I've cracked it, not very elegantly but I'm au fait with what I'm doing.
Thanks for looking at his if you have!

Please Login or Register  to view this content.