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

  • Durum: Closed
  • Ödül: $20
  • Alınan Girdiler: 9
  • Kazanan: imfarrukh47

Yarışma Özeti

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.

Tavsiye Edilen Beceriler

İşveren Geribildirimi

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

Profil Görüntüsü briandoherty22, United States.

Bu yarışmadan başlıca girdiler

Daha Fazla Katılım Görüntüle

Genel Açıklama Panosu

  • matthew34362
    matthew34362
    • 1 ay önce

    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 ay önce
  • imfarrukh47
    imfarrukh47
    • 1 ay önce

    do you need file? inbox me

    • 1 ay önce
  • matthew34362
    matthew34362
    • 1 ay önce

    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 ay önce
  • pogodin
    pogodin
    • 1 ay önce

    Hello !

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

    Thank You. Regards, Alexei.

    • 1 ay önce
  • imfarrukh47
    imfarrukh47
    • 1 ay önce

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

    • 1 ay önce
  • gato63
    gato63
    • 1 ay önce

    Hello, Please see #2 . Than you

    • 1 ay önce
  • mvchetty
    mvchetty
    • 1 ay önce

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

    • 1 ay önce
  • blui88
    blui88
    • 1 ay önce

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

    • 1 ay önce

Daha fazla yorum göster

Yarışmalara nasıl başlanır

  • Projenizi ilan edin

    Yarışmanızı İlan Edin Hızlı ve kolay

  • Tonlarca girdi alın

    Tonlarca Girdi Alın Bütün dünyadan

  • En iyi girdiyi seçin

    En iyi girdiyi seçin Dosyaları indirin - Kolay!

Şimdi bir Yarışma İlan Et ya da Bugün Bize Katılın!