Quick Excel VBA Code - 18/01/2020 16:40 EST

  • Status: Closed
  • Prize: $20
  • Entries Received: 9
  • Winner: imfarrukh47

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”

Profile image briandoherty22, United States.

Top entries from this contest

View More Entries

Public Clarification Board

  • matthew34362
    matthew34362
    • 1 month ago

    That's a sloppy solution chosen as the final "winner":

    1) It uses the clipboard to do a copy and paste, when all that was necessary was to assign the cell .Value field to the .Formula field without interfering with the Windows clipboard at all.

    2) It assumes any instance of the worksheet name in a cell is a reference to the worksheet. Text in a cell could mean anything. That's not parsing syntax. That's just ridiculously bad software design, making large assumptions. It could easily break in unpredictable ways in the future.

    • 1 month ago
  • imfarrukh47
    imfarrukh47
    • 1 month ago

    do you need file? inbox me

    • 1 month ago
  • matthew34362
    matthew34362
    • 1 month ago

    This is not as quick and simple as you think.

    The nested for loops over all sheets, all rows, all columns is the easy part, sure.

    But determining all references to a particular cell across from other worksheets (in a *reliable* way) is a parsing mess. Search the Web to find discussion about this by some pretty smart people if you don't believe me.

    • 1 month ago
  • pogodin
    pogodin
    • 1 month ago

    Hello !

    My experience with vba is more than 10 years.
    Can You upload example of xls file ?

    Thank You. Regards, Alexei.

    • 1 month ago
  • imfarrukh47
    imfarrukh47
    • 1 month ago

    hi please check #9 if you need it for testing inbox me

    • 1 month ago
  • gato63
    gato63
    • 1 month ago

    Hello, Please see #2 . Than you

    • 1 month ago
  • mvchetty
    mvchetty
    • 1 month ago

    Hi There, Please see the entry # 6 and contact me is there any questions. Cheers! - Murali

    • 1 month ago
  • blui88
    blui88
    • 1 month ago

    Hi please share your views about my entry # 5
    Regards
    Santosh

    • 1 month ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!