public

Thought it was my imagination... but... I have two public functions that I've defined which appear to be running as part of EVERY sub, regardless of if they are needed or not. [The public functions are called from my pivot table pages and are supposed to report back on which slicer items were...

I am getting a code break error in my formula - I need to auto sort wit a command key by column B but have all my columns pull into the sort - through column M. This is my first attempt at writing a macro. Please let me know what I am doing incorrectly. Public Sub Move_and_sort() Dim IR As...

Is there a way toset the value of a workbook variable from another variable that holds a string? I already have oneaction that does this by using ActiveWorkbook ,as shown below, but I have twoother workbooks that is are data templates, one of which will be opened up bythe macro. Public...

Hi all, I have 3 worksheets, one of these three is a master template. (sheet 3 for eg) I need to collect data from the other two sheets (sheet 1 and sheet 2) and send to the relevant cells on the master template. To do this I have assigned a set of global variables, hoping that I could set...

I've set up a worksheet to calculate holidays. There is a table consisting two columns. On column with dates, which include and days-off (holiday, public holidays and business trips) and another column with types of holiday ("holiday", "Public Holiday" and "business trip"). I use this table for...

Maybe something in here can be useful to someone maybe someone wants to critique. Workbook scripts: ' 03/2019' This workbook created Private Sub Workbook_Open() ' -------------Quick scroll to remove any date picker shadowing--------------- ActiveWindow.SmallScroll Down:=-15 '...

Hello there. Most puzzling. The following worked first time I tried it, now it fails on the highlighted line with Object does not support this property or method Simple test Hotel class: Option Explicit Private pName As String Public Property Get Name() As String Name = pName End...

I am trying to open a userform in one workbook from an event in my main code holding workbook. From a click of an object in workbook1 Private Sub lb_cntmissp_Click() If lb_cntmissp.Caption = "0" Then Exit Sub With wb_rd Application.Run wb_rd.Name & "!macro_01" End With End...

Hello I hope someone one can help: I want to try and achieve a code that will allow the Main volume to stay at Max but turn the Wave Input Volume (Sound from a website/Spotify etc) within the Mixer down individually when I play a sound through Excel. The code I have only turns down the...

Hi all, Thank you for spending your time to read the post. I have some questions regarding the excel. I am in the process of creating an excel workday calculator. The issue is 1. There are some working saturdays 2. There are some non-working holidays (which i grouped under public holidays)...

im trying to speed up my vba macro. i optimized my code as best i can. removed 99% .select .copy .paste etc turned what i can into with ws1 .bla .bla .bla end with code is 1000 times neater but if anything runs slower... i then found this code below...

Hello all, I got a combobox on my userform named cboxFunctionSearch This combobox is filled with the following code; Private Sub Init_cboxFunctionSearch()Dim X As Integer With Me.cboxFunctionSearch .Clear .AddItem "All" For X = 0 To Me.lstSearchResults.ListCount - 1 Call...

Ok, So I have a lot going on in this workbook and just trying to clean up all the script etc in this workbook and wanted to know if it is possible to declare everything below ALONG WITH Setting everything so when I get to the codes I dont have to "Set" anything just use the code like...

I wrote this project some 15 years ago and my wife has used it successfully for all these years to maintain our household finances. Very infrequently (maybe once a year) she will get the "Object variable not set" error. Of course I can get her up and running in a minute but I was always unable...

I am trying to develop a countdown timer that will countdown multiple segments from a Worksheet and keep track of the total countdown time. The following code works for the first segment, but when I read the second segment, my time starts counting by two, when I reach the third segment it...

99% of the questions on this group can be answered by anyone with zero VBA experience but with the willingness to spend a few of minutes googling around and trying out the code. This one is not. So please, I need help from someone who actually knows VBA, not newbies (like me) who need to get...

I have several spreadsheets with hundreds of hyperlinks to pics in one of the public drives. The links keep changing from where I originally set them to a roaming folder. It takes way more time than I have to keep manually entering the links to each cell when they change. Is there a way to...

Hi! This code works beautifully at work on Win 10 but not so much for Win 7 machines. They die on the MapNetworkDrive statement below. Is it due to Windows Credentials not being available? MapNetworkDrive 'Map SharePoint Online ATHLETICS...

Hello everybody. I'm in troubles while surfing a web site: the deadlock is the modal window you can see in the image. https://imgur.com/a/iq4KSDY It absolutely blocks every Excel actions: I've to manually click "OK" in order to unblock the process. I've tried the following solution, but...

I'm trying to automate a spreadsheet that calculates pay rates based on weekend weekday and public holidays. I have column A as the date starting 01/01/2019 Column B has the formula =TEXT(A1,"dddd") to add the day. Column C is a Vlookup to a Public Holidays table using the formula...