I'm a total noob and I'm struggling with this... Any help would be much appreciated!
I'm trying to set a range of multiple cells where the rows are fetched from the .Selection property but the columns are fixed values (A_:H_).
In case I wasn't clear enough regarding what I'm trying to accomplish, here are some examples:
if my Selection range is (B1:D9), I need to get (A1:H9) range.
if my Selection range is (C1:P4), I need to get (A1:H4) range.
if my Selection range is (AA76:BD55), I need to get (A76:H55) range.
Every tip is much appreciated!