Quick Excel VBA Code - 18/01/2020 16:40 EST
- Status: Closed
- Prize: $20
- Entries Received: 9
- Winner: imfarrukh47
I would like to get some VBA code written that does the following:
(1) In the active workbook, copy and paste as values all cells that link to the Active Worksheet
(2) Have a message box that says "Are you sure you would like to hardcode all references to this sheet?" With a Yes or No choice for the user.
The goal of the code is to be able to delete the sheet in the workbook without causing "#Ref" errors to come up in the workbook.
Please submit a .txt file.
“I have worked with many freelancers on VBA projects and Furrukh is among the best”
briandoherty22, United States.