codenames

  1. J

    Check if a file can be opened or not and delete if not

    Hi, does anyone have a code that can go through a list of hyperlinks and check if they can be opened or not? Some may be corrupt which is the reason they cannot be opened. This is what I have so far but the error command doesn't seem to work. The aim is to delete the hyperlinks that cannot be...
  2. L

    Using Codename In A Loop - How To Refer?

    Hey, So I've started to pick up on using codenames when writing scripts, majority of them I can pull them off or learn the workaround but in my example.. say I have 10 sheets, all codenames are sheet1, sheet2, sheet3 etc.. why does this code not work when referring? Why does it not pick up as...
  3. A

    Better way to reference / use worksheet codenames?

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I recently switched to using worksheet code names vs. worksheet names in my code because of some advantages I thought would benefit me. One inherent problem I didn’t anticipate...
  4. T

    VBA looping through sheets codenames

    Hi, I am solving a problem. I need a macro, that does certain operations on several sheets in workbook, but due to the actual sheet names changing based on specific projects and people adding new sheets, the only viable option is refering the the sheets by their codenames. Can you loop through...
  5. C

    vba to clear contents of the same range across multiple sheets

    Hi, I'm looking for some simple, efficient code that will clear the contents of the range A2:GR50000 across 50 worksheets. I need to use sheet CodeNames in the vba. Does anyone know what the fastest vba solution would be? Thanks.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top