broken code

  1. T

    VBA For loop suddenly broken--what happened?

    This sub used to work perfectly. Then I added the variable misCell in the sub declaration and in the first line of code, and for some reason, the ElseIf statement in the first For loop is now broken. Nothing in that code changed (as far as I know). But suddenly it is filling all the "TOEZ...
  2. E

    VBA Stopped Working

    Hi All I'm not sure whats happened but i had the below codes written so that if i changed either 'A5' or 'A10' all columns between 2 - 100 would hide except the columns with heading that match 'A5' or 'A10'. This is a little above me i wrote most of it from this web site and Youtube, and it...
  3. H

    Comparing Columns VBA Assistance Required!

    Hello! Excel, VBA 2010 I've been fiddling with this subroutine for a few days now and for a while it worked fine. I've finished the entire spreadsheet and this broke.... I can't seem to figure out what's wrong with it. I hacked this from wellsr.com and reformatted it to what I need. This is...
  4. D

    Creating Pivot Table and Pivot Chart in a new sheet (Code no longer works)

    Hi guys, I had created a piece of code which created a pivot table from a range of data into a new sheet. The code then create a pie chart from this data. For some reason I think I messed with the pivot table elementof the code and it no longer works. I keep receiving an error referring to...

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