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