Using the result of ADDRESS() function as a range for VBA function

Unfortunately the internal Excel Add-in that I'm using here can only use a comment as a data input. It seems I will have to make a Sub() procedure then.