activesheet.showalldata

Hello, Sub Reset_Filters() ' ' Reset_Filters Macro ' Resets all filters ' ' ActiveSheet.ShowAllData End Sub If there are no filters applied, I am getting the below error message when the macro is run (it's assigned to a button): And when I debug Kind Regards

No clue why this works on my machine, but throws a 438 on another user's machine. Anybody? This is all my code. It's my boss, so I didn't exactly want to get him involved in debugging. Let me know if I MUST. I figure it's something I can't pick out because I steal code, I don't really write...

I'm trying to set zoom level as well as each sheet having the last empty cell selected. I have a button on each sheet which manually selects and scrolls to the last cell using:- ActiveSheet.ShowAllData Range("Table1").Cells(1, 2).End(xlDown).Offset(1).Select...

I cannot get my new Excel 2016 to loop through worksheets. Just runs the code the same number of times there are sheets, but not on the sheets. Sub Don_StepALL() ' ' Macro1 Macro ' ' Dim ws As Worksheet For Each ws In Sheets Range("K2").Select ActiveCell.FormulaR1C1 = _...