I have developed the following Macro in order to- update, hide some columns and save the file.
But, it keeps giving me the following error: This action will cancel pending data updates. Would you like to continue?- And, it does not matter whether yes or no, because the data is not...
I have a master sheet with Columns dated across starting from 01/07/16 in Cell B1, 02/07/16 in Cell C1 and so on across.
I have charts that are connected with the master sheet and I want it to update each day with only data that is entered so that the charts arent showing loads of empty...
Hi, I am looking for a macro to hide all rows that have the word "detail" in column B. This will ultimately be assigned to a button. I feel like this should be an easy one, but I seem unable to get the If function to work. Any help is appreciated.
Hi I have a macro that sits within different sheets in my workbook and hides rows based on the result in a cell.
I thought this was great until I added in Forms Check Boxes yesterday and found that rather than hide, these boxes just move down the page.
Is there any way to get the check boxes on...