I am trying to trim clean column A then filter the blank cells in column A and delete the entire row based on blank cell present in column A. Column A has a fe
I get error number 5 in (ActiveSheet.Cells(Rows.Count, 3).End(xlUp).Offset(1, 0) = Left(file.Name, InStrRev(file.Name, ".") - 1) The purpose of this code is
I have below a list of data(Sample data) in a single column in multiple rows in excel. I would like to categorize data into multiple columns like Type, Amount,
I'm quite new to VBA. I have a workbook named Fruit. It has multiple worksheets such as Apple, Orange, Grape and so on. In a certain folder, I have workbooks wh
I'm trying to run a compare though multiple sheets. I get Runtime error 9 subscript out of range Sub Comp_TEST() Dim ar As Variant Dim var() Dim i As Long Dim
I am trying Excel.WebImageCellValue interface in Excel Script Lab. Here is my test code /** * show image * @customfunction * @param {string} imagePath * @re
I am trying to get email addresses from a worksheet(Sheet1) into the .To line for an outlook email based on the specific string value in the main worksheet. I h
How do I evaluate dates, as seen as below? According to this list, https://www.techonthenet.com/excel/formulas/index_vba.php, all the functions in the formula
I´m exporting data to excel with the columns like ID Product Quantity Price Sum Our vendors fill in the Quantity and Price. I want to pass a simple calcul
I'm using EPPlus in my C# code to create an Excel workbook. My code includes this statement: ws.Cells[1, 1].Formula = "=UNICHAR(160)"; But when I execute
I'am writing simple code like nextCell.Value = dateJour.Value, were dateJour is a date located in a cell in the workbook. When I loop (about 100 times) it takes
The datasets are small (10-25 lines), but I have to run a lot of them and it's getting to be a waste of time. The original data looks like this: The output need
The datasets are small (10-25 lines), but I have to run a lot of them and it's getting to be a waste of time. The original data looks like this: The output need
I have two sheets; Sheet1 & Sheet2 and want to link the format from A1 Sheet1 to A1 Sheet2, i.e. Sheet2 A1 should match the formatting of Sheet1 A1 I don't
I made a button that adds a new row above another row where the value of the cell in column C is "add row above". I did it like this because there is a formula
I have a button click that attempts to export a DevExpress pivot grid to an excel file however when you open the file in excel or google sheets it zeroes some o
I have the following two tables in excel. Table 1 contains the date, closing share price and log. In the second table, i have the date and the number of years
I have a script within an excel that needs to loop through whichever folder its in on the Sharepoint, and attach it to an email. As I understand I need a direct
I have two worksheets, one with all of my raw data (Base) and the other housing information submitted from a form (Sheet 1). I am trying to find any duplicate I
It is a movie dataset in a simple pivot table where the row fields are by the years the movies were released and for columns I have used "box office revenue" as