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'm trying to center the table content using df.style.set_properties(**{'text-align': 'center'}). But I couldn't do it. Is there any other way? Here is the full
I want to set local variables or pass parameters from Excel to SQL. I've found similar questions, but all referred to old versions of Excel and/or the answers s
Wordy title but I was interviewed on this question, couldn't derive the answer and really would love to better understand array usage in excel. Question: You ha
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
Is there a code or function in excel to do the following: If F8=blank, cut and paste text in G8 in G7 next to text separated by semi-colon.
I have a Power query that finds and replaces values listed in a table that I work through from here Bulk Find And Replace In Power Query But I need to apply it
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 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 huge spreadsheet of data that looks something like this: Date IDNumber Item 2021-05-10 1 Apple 2021-05-10 1 Orange 2021-05-10 2 Apple 2021-05-10 2 Gra
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 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
> STUDENT SCORE VALID DIF 1 83 YES 0 1 77 YES -6 1 2 NO -99 1 66 YES -11 1 100 YES 34 2 68 YES 0 2 98 NO -99 2 61 YES -7 2
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 want to link a "TimePicker" housed on an Excel macro enabled spreadsheet (it has three textboxes for hrs, min, AM/PM with associated SpinnerButtons [SBs] oper
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
I got an excel file which should use a query from an ms access file (which is a front end for a ms sql server) But instead of receiving every entry I want to us