quick

I have made some macros and added them to a user form. Everything is saved in an Add In file that is deployed to all users. I made a guide how the users can create a Quick Access button, but if I password protect my VBA project the users can’t see the main macro (public) when trying to add it...

I have a cell with "42059 Completed QualityReviewed" in it. I just want to extract the number itself to another cell. Any help would be appreciated.

Hi all, Hope everyone's enjoying their Holidays. Please help. I inherited a spreadsheet with formulas that refer to a separate range. With each new month, the entire range needs to move over one column to consider only the latest (12 mo) periods. Is there a quick and easy way to change the...

Sure we've done this before but it's something I have to do every now and again and can never remember a simple way to do it from one time to the next: 'copper days' start at 6am - so 'today' doesn't finish until 5:59 tomorrow morning - 24/12/18 03:00:00 is really 23/12/18 24/12/18...

Is there a way to hide a list of PivotItems in a single command? Using Excel2010, standard pivot (not OLAP data source) I'm looking for a way to significantly speed up the code execution. NB I already suspended the recalculation, the video refresh, set .ManualUpdate = True, ... So I'm...

Is there a way to change the colour of Excel/Word icons on the ribbon and quick access bars? Or a download?

Hey Guys, quick question. Cell R17 is a time value in hours, input by the user as "HH.h" meaning its hours and a decimal (5.5 hours for example). Cell D8 is a whole number (hours) (5 hours) Cell F8 is a whole number (minutes) (30 minutes) I'd like a quick IF Then that says IF R17 > (D8 +...

Hello I've created a read only workbook that gets saved as another file name. I've added a macro to the quick access toolbar that opens a userform. However, when in a workbook that is saved as a different name, the macro on the quick access toolbar always opens the original workbook with the...

Hello! Is there a quick way to generate a list of the weekday dates between a starting and an ending date? Without weekends? Thanks!

I have excel data vertical. However, the files I am getting to upload has the data horizontally. Is there a quick and fast way of changing the format to horizontal? Using Excel to transpose it, will take a long time.

Hi, I created a set of macros that I need to be able to call whatever the workbook is openned. For example: Public Sub ResetFullLayout() '**---------------------------------------------------- '** '** Purpose: Reset layout to view all columns and all data '** '** Input: none '** '**...

Yesterday, accidentally deleted some of the records in MDB file. Any quick and reliable way to fix it?

We just upgraded to Excel 2016 - I cannot find the "open recent file" icon for my quick access toolbar. Is it no longer available in Excel 2016??

Hi guys. Sorry this has been asked before, but I couldn't get it to work with the info on the other post and as it was a bit dated, I didn't want to bump it. So I am a total noob with VB, but I'm assuming this can be done. If I have many tabs, is there an a quick way to put all that data onto...

Hi Everyone, Is there a way of adding an icon to run a macro, using vba onto the quick access toolbar, I know you can manually do it, but I wish to add it via VBA if that's possible, I can't find any discussions with any solutions as yet! Thanks for reading :)

Hi Excel peoples I'm using a Listbox which contains three selectable items - the idea being that people can select any number/combination of the three as they see fit. It works fine but the linked cell reports '0' when more than 1 item on the listbox is selected. I've read around and the only...

Sorry to post on an Excel board... But I need a quick way to save multiple Word.docs as multiple PDF's. Possible ? Thank you!

Need help with the formula =COUNTIF(C12:H23,1)+COUNTIF(C12:H23,2) Where C13:H23 = Named Range Week_1 I already know indirect has its drawbacks im just doing some quick and dirty analysis. Thanks for the help

Hopefully a quick question all The following line of code is failing Sheets("ChartByCount").FullSeriesCollection(5).AxisGroup = 2 I get a runtime error; "Method 'AxisGroup' of object 'Series' failed" Must be a syntax problem or something equally simple, but I can find the problem Any help...

I have 2 columns of data. I need to count how many Advanced are also Safety and so on and so forth. How many Major are Safety, CD, etc. How many Advanced are Safety, CD, etc. ??? <tbody> Advanced Safety Major CD Standard PD Advanced Safety Advanced PD Major QC Advanced PD...