Quick Excel VBA Code - 18/01/2020 16:40 EST
- Status: Closed
- Prize: $20
- Entries Received: 9
- Winner: Farrukh Saeed
Contest Brief
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.
Recommended Skills
Employer Feedback
“I have worked with many freelancers on VBA projects and Furrukh is among the best”
briandoherty22, United States.
Top entries from this contest
-
Farrukh Saeed Pakistan
-
babusamrat Bangladesh
-
pogodin Belarus
-
Muhammadadil1 Pakistan
-
gato63 Venezuela
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!