So I am trying to calculate a test temp for 1hr from the last 12 hours of data. Sometimes this data can be several days some times it can be only 24hrs. The sta
I am working in VBA, and I need to set the .Interior property of a Range object, to the value of its own .DisplayFormat.Interior. More generally, I want to pas
I'm trying to find a native Excel function (or combination thereof) which will behave precisely in the manner of COUNTIF (i.e will handle wildcards), but is cas
So we are trying to create some ppt report based on excell data. I'd like for the first slide to have a background image or just an image that is set behind the
Very specific question. I got a task to learn vba, but i cant really find anything for my problem. screenshot of how it looks in project Basically if the column
I'm trying to make an Excel VBA macro to automate my saves. So if it is 2022 or 2023 and it is either the month of January, February, march, etc. The file will
I have 20 cases. For every row in my sheet, I have a cell that assigns related case numbers to it. A row could have multiple case numbers assigned to it in that
I was writing a simple script in VBA for batch updating project info posted on Project Web App. I've stumbled on a problem which seems unsolvable to me though,
iam gettin an error while running below code, i want to apply pivot table to dynamic data range ( data gets change everytime i.e rows and columns) i want macro
I am doing Excel VBA code to send emails from Outlook. This is working so far. I would like to add a couple of buttons (or links) inside the email body. The rec
see the basic function structure function test (first as range) whatever I do inside end function calling the function and first is the address of the first c
I can declare a static byte array in VBA like this, but it appears that the elements are not of type byte. Dim A As Variant A = Array(&H9F, &H2C, &H
I am not trained with coding in any way, but have in the past managed to use codes I found online as part of excel or access using macros or buttons and things.
I have a macro which theoretically works perfectly but I think it is creating unnecessary processing and calculation requirements which then crashes the file. I
I am a newbie to vba code but have had some marginal success with basic macros for changing the format of tables, text and photos within Word documents. I have
I built a VBA Sub that matches an input string with the equivalent string within a large array and returns a specific string which is bounded to the matched str
I am new to the forum and VBA codes. I have been searching for an answer to this question and am completely lost. I have a workbook that contains around 36 work
I have a VBA User defined function which takes multiple range references for using it in the code. My problem is when I try to use a particular range reference
so i'm trying to use a macro to look in sheets one code and paste the information of that code , I'm trying to use a simple macro with advanced filters to do th
I was using selenium with VBA and there is the current webpage. I was trying to get the bot to select the "exportbutton" ID, but I have already tried Findelemen