I tried the following to filter (between filter) my worksheet based on 2 values. The 2 values are input in textbx1 and textbox2 in userform 'A1_Filter_Range'.
I have a lot of PDFs to convert to excel. I found the code below which converts PDF to excel by opening the pdf file in word but it fails at Dim fso As New File
I have a column with 595 rows. Then I proceeded to add 20. (Note this excel sheet with the 595 entries was already in place before I started working on it. The
I have been using this code in office 2013: With OutMail .Attachments.Add fName .HTMLBody = .HTMLBody & "<br><B>" &
I am trying to set some custom(from hexcode or rgb value) color to a xssfcell.But the color of the cell is becoming black even though I am giving some other col
I have a script that pulls the first cell value of a table from a database and adds it 10 times. I want to write that list to excel. Here's what I have so far:
I have a column for age and a column for gender. How can I get the number of people with ages between 0-18 and with a gender of "male"? For example, with the fo
I have an excel based bank reconciliation that I'm doing a manual matching like the example below using ABS or conditional format, but I need to do a faster mat
i have about ten responses from StackOverflow open but none of them quite answer my problem. i have created several UserForms in Excel VBA for this particula
I am trying to upload multiple Excels files (same format) and each of these files has multiple sheets, in nature each Excel file has information about a hotel b
I need help reading all the rows from excel sheet as a test data in my selenium test case. I can read only one row of an excel sheet with the following code.
I have a worksheet that uses randomly generated numbers in calculations to produce results in two adjacent cells (let's say A1 and A2). I am trying to perform
I’m trying to create a series of input boxes that will prompt for more information before executing the rest of the code. I’m stuck on the looping a
Below is my code where I'm trying to export a MS Access query output to an Excel file and then editing the Excel to create a pivot table on a new sheet. The cod
I am trying to apply filter from a master worksheet to multiple worksheets in the same workbook. eg. There are 3 worksheets in the workbook, with following fi
Whenever I open the worksheet, I wish the current Month name row to be adjusted at the top of worksheet. I entered month name in cell E2-January, then after 115
I am trying to export a MS Access query to an Excel file and then create pivot tables in the excel file based on the data dump extracted to the excel file. My i
I'm writing a program to read a large xml file and create an excel file from it. The attributes of each node will be the column headers in excel file. I created
In Workbook.Open() I have an Application.OnKey for every letter on the keyboard and all the numbers. The letters open a sub LetterPress(L as String) Example for
I'm trying to turn general data written as fractions like 3/4" or 13 7/32" into 3 place decimal numbers such as 0.750 or 13.219. I have a working table replacem