Hi and welcome to the forum

Can't record this in macros.
do you mean you do not want to use a macro, or that you do not know how to make a macro for this?