I have the below line of code. What can I add to it, to make it only copy values, not formulas?
thanks
![]()
Sheets(TabName).Copy After:=Workbooks(ControlFile).Sheets(1)
I have the below line of code. What can I add to it, to make it only copy values, not formulas?
thanks
![]()
Sheets(TabName).Copy After:=Workbooks(ControlFile).Sheets(1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks