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

  • Status: Closed
  • Præmier: $20
  • Modtagne indlæg: 9
  • Vinder: imfarrukh47

Konkurrence Instruktioner

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.

Anbefalede Evner

Arbejdsgiverfeedback

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

Profilbillede briandoherty22, United States.

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig Præciserings Opslagstavle

  • matthew34362
    matthew34362
    • 1 måned 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.

    • 1 måned siden
  • imfarrukh47
    imfarrukh47
    • 1 måned siden

    do you need file? inbox me

    • 1 måned siden
  • matthew34362
    matthew34362
    • 1 måned 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.

    • 1 måned siden
  • pogodin
    pogodin
    • 1 måned siden

    Hello !

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

    Thank You. Regards, Alexei.

    • 1 måned siden
  • imfarrukh47
    imfarrukh47
    • 1 måned siden

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

    • 1 måned siden
  • gato63
    gato63
    • 1 måned siden

    Hello, Please see #2 . Than you

    • 1 måned siden
  • mvchetty
    mvchetty
    • 1 måned siden

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

    • 1 måned siden
  • blui88
    blui88
    • 1 måned siden

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

    • 1 måned siden

Vis flere kommentarer

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!