HI All - Very new to this forum and also vba. I don't know much, so I appreciate any help.
I currently have this code. It copies and pastes data from a specific range that I've specified of multiple workbooks of a specific tab, into a master sheet. The data from each workbook is pasted directly under the information that it collected from the last workbook that was opened.
It is currently pasting the formulas; however, I need it to paste values only. Can anyone edit this code to fix that? Other than this, it works perfectly.
Thanks!
Ron
Please Login or Register to view this content.
Bookmarks