excel vba show all data error Crum West Virginia

Address 7821 Beauty Rd, Beauty, KY 41203
Phone (606) 395-6600
Website Link http://www.ekycs.com

excel vba show all data error Crum, West Virginia

Any suggestion??? > > > > > > > > Thanks, > > > > > > > > Jacob > > > > > > > > Dave Peterson wrote: Join them; it only takes a minute: Sign up Run-time error '1004' ShowAllData method of Worksheets class failed up vote 1 down vote favorite Iam getting confused. It does seem to work, however? If I were to share the workbook I guess I give > > > read only access to it.

It is as follows: Private Sub Workbook_BeforeClose(Cancel As Boolean) Range("A1").Select ActiveSheet.ShowAllData ActiveWorkbook.Save End Sub The top row has the autofilter on. How can I get > around the problem when it happens to _already_ show all the data, pls? > > Thank you! -- Dave Peterson Dave Peterson, Jun 29, 2004 I think it would be an if then statement but my coding > skills aren't quite up the par. > > Any help would be great. To start viewing messages, select the forum that you want to visit from the selection below.

Can someone try to explain this for me. Share Share this post on Digg Del.icio.us Technorati Twitter Regards, BatmanUK Reply With Quote Oct 15th, 2006,01:04 PM #6 BatmanUK Board Regular Join Date Jul 2006 Location Northampton, England Posts 185 Your feedback about this content is important.Let us know what you think. How to solve the old 'gun on a spaceship' problem?

Is intelligence the "natural" product of evolution? Thanks, Jacob Jacob wrote: > Dave, > > The me.saved = true worked fine if I didn't try to filter anything. > Once I did it ask me to save. The .FilterMode property tests for whether one or more filters are actually applied. more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation

Did Sputnik 1 have attitude control? So, say in a column you have data like 1, 2, 3, 4, 5. I think it would be an if then statement but my coding > > > > skills aren't quite up the par. > > > > > > > > Any If it is > filtered the Macro runs fine. > > I can't seems to find the right code to get the macro to end if it > errors out.

To remove an applied filter but leave AutoFilter on: If ActiveSheet.AutoFilterMode Or ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If The rationale behind the above code is to test that there is an AutoFilter I'm not able to understand this. –Kris Van den Bergh Aug 14 '13 at 8:16 @KrisVandenBergh I'm glad the initial problem is solved :) If there is another problem Example This example makes all data on Sheet1 visible. After some trial-and-error I discovered that if the selection was to the right of my filter area AND the number of shown records was zero, ShowAllData would fail.

Normal (single) sheet Filter can be accessable simply through Worksheet object. –Axelock May 20 at 9:57 add a comment| protected by Community♦ Aug 22 '14 at 14:44 Thank you for your Grom View Profile View Forum Posts Development Team Member Join Date 17th November 2005 Location North East Pennsylvania, USA Posts 695 Re: ShowAllData method of Worksheet class failed sjvondra2, The following Is it appropriate to tell my coworker my mom passed away? Maybe: > > With me.worksheets("sheet9999") > .select > .range("a1").select > If .FilterMode Then > .ShowAllData > End If > End With > > just in case the wrong sheet was active.

All > > that the worksheet contain is like a contact list, plus I am the only > > one currently using it. I have thought about > > putting the code when the workbook opens, but then I want to get around > > not having to click the "Do you want to Is the NHS wrong about passwords? Maybe: > > > > > > With me.worksheets("sheet9999") > > > .select > > > .range("a1").select > > > If .FilterMode Then > > > .ShowAllData > > > End

Sometimes it runs with no error while 10 minutes later ill get the error message in the Title field, and it stops at the LAST ActiveSheet.ShowAllData It so unlogical for mer Just click the sign up button to choose a username and then you can ask your own questions on the forum. I've not really looked into the AutoFilterMode and FilterMode properties too deeply. Is there a place in academia for someone who compulsively solves every problem on their own?

Not the answer you're looking for? Similar Threads Ranking within a Filtered Worksheet Ralph Noble, Nov 26, 2003, in forum: Microsoft Excel Discussion Replies: 1 Views: 1,730 Debra Dalgleish Nov 26, 2003 Excel 2002 - subtotal function Jacob wrote: > > I have a macro to run right before the workbook closes. Home » ExcelBanter forum » Excel Newsgroups » Excel Programming Show All Data Author Name Remember Me?

Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? Maybe: > > > > > > > > > > With me.worksheets("sheet9999") > > > > > .select > > > > > .range("a1").select > > > > > If Any suggestion??? > > > > Thanks, > > > > Jacob > > > > Dave Peterson wrote: > > > With ActiveSheet > > > If .FilterMode Then > I still get the error "ShowAllData method of worksheet class failed" Mike Code: With Worksheets("ActualData") If .AutoFilterMode Then Worksheets("ActualData").ShowAllData End If End With Share Share this post on Digg Del.icio.us Technorati

What are "desires of the flesh"? Excel Video Tutorials / Excel Dashboards Reports Reply With Quote August 20th, 2013 #2 Stanley D. Is there a way to surpass the dialog box? Community Resources O365 Technical Network MSDN Forums UserVoice Stack Overflow Follow Us Twitter Facebook Office Dev Blog © 2016 Microsoft United States - English Terms of Use Trademarks Privacy Statement ©