Hi,
I am using this subroutine to call for some data using formulas from a different sheet.
One of the things that I am sytruggling with is whatever ranges are using this subroutine I want it to copy values and formats.
Any suggestions?

HTML Code: