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

  • Status: Closed
  • Premie: $20
  • Mottatte bidrag: 9
  • Vinner: Farrukh Saeed

Konkurransesammendrag

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.

Anbefalte ferdigheter

Arbeidsgivers tilbakemelding

“I have worked with many freelancers on VBA projects and Furrukh is among the best”

Profilbilde briandoherty22, United States.

Beste bidrag i denne konkurransen

Se flere innlegg

Offentlig avklaringstavle

  • matthew34362
    matthew34362
    • 4 år siden

    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.

    • 4 år siden
  • Farrukh Saeed
    Farrukh Saeed
    • 4 år siden

    do you need file? inbox me

    • 4 år siden
  • matthew34362
    matthew34362
    • 4 år siden

    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.

    • 4 år siden
  • pogodin
    pogodin
    • 4 år siden

    Hello !

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

    Thank You. Regards, Alexei.

    • 4 år siden
  • Farrukh Saeed
    Farrukh Saeed
    • 4 år siden

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

    • 4 år siden
  • gato63
    gato63
    • 4 år siden

    Hello, Please see #2 . Than you

    • 4 år siden
  • mvchetty
    mvchetty
    • 4 år siden

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

    • 4 år siden
  • blui88
    blui88
    • 4 år siden

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

    • 4 år siden

Vis flere kommentarer

Hvordan å komme i gang med konkurranser

  • Legg ut din konkurransen

    Legg ut din konkurranse Raskt og enkelt

  • Få mange bidrag

    Få mange bidrag Fra hele verden

  • Kår det beste bidraget

    Kår det beste bidraget Last ned filene - Enkelt!

Legg ut en konkurranse nå eller bli med i dag!