Welcome to VBAX Goodstudent6.
is there a way to achieve this using VBA?
Sorry, but you need to explain this a little better?