2010 macros

Guys, On my work machine I was running XP and 2007 Excel. While we migrated to 2010 Excel and Windows 7 Enterprise I needed to use a few project plans. These contained a few macros and were password protected docs. I use Excel 2016 at home so just opened them on USB. Now when I try and open...

I have a macro that went from running in 1-2 minutes in 2003 to taking 35-40 minutes in 2010. I have been trying to figure out what is causing the slow down. I think I have narrorwed it to this section of code. Public Property Get StartRow(sheetName, TextValue, Optional theOccurrence As...

I have a spreadsheet with drop down criteria that queries a database. A 'command button' prompts the user to 'refresh' the data. The macro is very simple. ' ActiveWorkbook.RefreshAll ' When 'clicked' on a 64 bit pc - Excel crashes. The only way out is to 'End Process' via Task Manager. If I...

Hi, Is there a way to use a 'not' with an array in autofilter? I'd like to show all rows excluding those in the array. see below code: Sub filtertitle() Dim lr As Long lr = Cells(Rows.count, 1).End(xlUp).Row [a1].CurrentRegion.Select Selection.AutoFilter Range(Cells(1, 1), Cells(lr...

I export a query report from Access to excel daily. It is a pretty simple report it just has to be formatted correctly as it is then loaded into an Oracle upload. The macro works fine on my pc at work. The macro worked fine on the pc of a coworker who sometimes helps me. It worked for my...