Macro Not working right!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ive set up a macro to hide blank qty and show blank qty for a workbook with
about 30templetes. On some templetes the macro works fine, but there are some
templetes where when i hit hide blank qty it hides all blank qty but also
hides a section where i have text in it. It only happens on a few and the
macros are all set up the same. Help here would be appreciated!!!
 
You will need to post your code to get help. Only a few of us (I'm not
included) are able to read and debug code that hasn't been posted.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Sorry Macro code as follows:
Case "8200_8210"
ActiveSheet.Cells(6, 38).AutoFilter field:=5, Criteria1:="<>"

And it is the same for all worksheets except the Case name is named
differently.
I have filled the blank cells with a 1 so that the macro doesn't hide that
cell. But on certain sheets in the workbook it hides our terms and
conditions. Does that make sense? Or did i need to send you a copy of the
templete so you can further understand what i am trying to do.

thanks
Mary
 
Back
Top