What does the statement Selection.QueryTable.Refresh BackgroundQuery:=False do in excel macro? Does it disable background refresh for the selected table?
I have some conditional formatting together with a module, that for some reason prevents my macros from running all the way through. =NOT(TestColor(E8)) is my c
i know this question has been asked many times , i have read through the answers of previously asked question however im still not getting how to open the file
I am using the below code to: Delete the similar rows, keeping only one and combine cells values in the range "N", separated by vbLf it works ,but with big rang
I would like to preprocess (lower case, remove stopwords, lemmatization, remove punctuation ecc...) the text contained in the cells of a column of an excel file
I'm trying to mimic Lighthouse performance calculator but I don't know the formula for it. Say the weighted percentage from their website is: FCP : 10% SI : 10%
I am after a way to pull a consistent group of rows with an equal spacing between each. Example: My data range is in A3:A250. I'd like to pull A3:A10,A15:A22,A2
I am currently working on a Word-document I want to use as a template. This template provides a "structure" including many bookmakrs. The template is filled usi
I am using code on Outlook to hide the mouse cursor on Outlook before opening the attached workbook: Private Declare Function ShowCursor Lib "USER32" (ByVal fSh
I used xlwings to open excel workbook. It worked fine up to last month. But today, when I run the same code, it opened my worksheet but convert my worksheet nam
I use a MS Form to collect Data and use an xlsm.file where I copy the new data and then further work with the data. In order to update the data, I have to Open
Please help me with the code to insert a column in excel using vba. Here is what I am doing - Sheet1.Range("A:A").EntireColumn.insert
When running automatically via Workbook_Open, it throws a 91 error. However, running the same code manually does not. It's machine specific. No problems on a
I need to filter a collection that have "HoldingSubholding" column, that can have lot of different value. I need All the rows with the values except the rows th
When IE gets removed from Windows, will this impact XMLHTTP60 and my Excel VBA code? How could one confirm?
Sorting I need help in the below formula that I am using to number the above table in the "Sorted Numbering" column. The formula that I am using basis which th
There is an xlsm file which I need to open and edit and extract data as per the macros enabled in the sheet. But I'm not able to open the file itself. I tried:
I have a spreadsheet of identification numbers, and various results for each. I used a couple formula to see if the subject passed or failed any of a set of cri
I am trying to copy a whole pdf document into excel using the following code. The code works perfectly except for the paste part, when it gives me the following
I am trying to insert 2 different ranges "x" amount of times based on the input from the user. The user chooses how many mounts they need "D22" and a range is c