Yes I did try recording the macro by recording the steps but it didn't work.