I have a macro here which works by going through a folder and extracting individual and a selection of cells. I am getting an automation error when the macro steps into picking a selection of cells to copy. The first senerio works, but any copying senerios after that does not. The first attempt to copy and paste a selection that is working is printing #REF! though; is there someting im missing in my code to call the value instead of the formula? and is there a noticble error in my code that is causing an automation error?