Recent content by patsfan

Thanks Chihiro, for taking the time to help me out. It is appreciated.

Thanks Chihiro, I used the latter and it cut the loop time in half. I also saved some time by exiting the loop when all remaining conditions allowed me to do so. However, for certain loops, it still takes about 30 seconds to loop through the slicer items. I was unable to piece together...

Guys, I have a pivot slicer listing 52 different week date filters. There are some time filter options to provide users with specific totals. "Last 52 Weeks", "Last 26 Weeks", "Last 13 Weeks", "Month to Date", etc. When a time filter is changed, it is taking about 1.5 minutes to return results...

Thanks John, I appreciate the info.

I'm having difficulty trying to find a way for the VBA status bar to reflect the name of the sub procedure. I have numerous sub procedures and instead of hard coding the Application.Statusbar = "private sub 123()", I would like the status bar to reflect the name of the current sub procedure...

Thanks for responding PCosta... that is what I ended up doing. And thanks Moderator for moving to the VBA section... now I know it exists. LOL.

I've been running a macro daily for over 5 years that would automatically activate each workbook after opening. Beginning this morning, when VBA opens a file, it does not automatically activate it. Workbooks.Open Filename:="\\jupiter\projects\macrofile.xls" I've tried this on three different...

In the event anyone is interested... Although the method Chihiro suggested would have been preferred, I didn't really have the time to set that up... along with the fear that I would mess up some company IT security setting... along with my machine. My short term fix (and easier to...

Thanks Chihiro... I appreciate the response. Looks like I have some work to do.

Greetings, Is it possible to create hyperlinks to websites and folders within a custom tab group? I have a custom tab which I want to populate with shortcuts to research sites and shortcuts to network folders (where I can then open a new file). I currently have the hyperlinks available within...

Thanks Narayan for taking the time to help me. As you mentioned, I also noticed that if I clear the cells from the bottom up, it reduces the time to update. Thanks to all you guys, I am constantly learning and applying more efficient methods to building my spreadsheets.

Thanks but that isn't speeding up the process. I removed all references to this column from the other formulas. I am assuming since my formula references all other cells above each one, in the same column, is why it's taking so long. I was using this formula below to capture a unique list...

Yes, the results from this column were referenced (index/match) on a couple other sheets. usually took about 5-6 seconds to calculate.

Does anyone know how to efficiently remove an entire column of formulas? I have about 45,000 rows in one column with an "IF, IF, COUNTIF, MAX" formula and I cannot seem to quickly remove it. I've tried, copy/paste values, find/replace "=" to a text character, turning off calculation, deleting...

Thanks Luke. I appreciate the quick response.