Category "excel"

How to change value of iRow depending on object value?

I am looking for the iRow value to be dependent on whether the object value. I have 2 buttons: Private Sub OptionButton1_Click() End Sub and Private Sub Optio

Subtract the date from each cell in a column, skip cells that have string values

I have an Excel sheet of expiration dates. Some rows lack an expiration date so I chose to fill those cells with the string “NO DATA”. I want to loo

Array only fills on first iteration of loop

I have a results table with multiple results for multiple samples, and a sample list array containing each unique sample reference value in the results table. I

Retrieving a zip file from a web site using Excel VBA

I'm trying to download a zip file from a public web site http://serviciosede.mineco.gob.es/indeco/BDSICE/homebdsice.aspx. To download the file this site execute

Difference between excel's and python R2, Power fit

I'm trying to do a power fitting of the x and y arrays and estimate also the R2. I have already done it with excel and it gives me an R2 of 0.5389 while if I ru

In openpyxl, is there a way to see what conditional formatting rule(s) are applied to a cell?

I'm using openpyxl 2.5.6 and py 3.7.0. My goal is to read an Excel workbook and print both the contents and the formatting of each cell into a CSV. For instance

VLOOKUP With Duplicate Values

I have 2 sheets like the following: Sheet 1 Sheet 2 I want to enter the values ​​from column B on Sheet 2 into column B on Sheet 1. In Sheet 1 the

Listbox search and delete

My datasheet: sheet ("Database") - A1 to L10000 (entries) Headers of each Column in A1 to L1 I tried to search the sheet with a userform. I used a ComboBox beca

How to remove special characters from columns D and F?

I have data in column D and F which might have special characters (, . / + &() etc.). I want to remove the special characters if any and trim clean the colu

Apache POI: default Excel cell styles

Is there are a way to use default Excel cell styles (see below) in Apache POI, similar to default data formats in BuiltinFormats?

Clean trim cells from column A and delete entire row with blank cell in column A

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

Returning file name with Left(file.Name, InStrRev(file.Name, ".") - 1) generates error number 5

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

Transpose the row data to column

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,

Copying data from multiple worksheets on a workbook to other workbooks that each have the same name as the current worksheets while they are closed

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

How to run a compare though multiple sheets?

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

Excel Custom Function return WebImage not showing

I am trying Excel.WebImageCellValue interface in Excel Script Lab. Here is my test code /** * show image * @customfunction * @param {string} imagePath * @re

Checking a string value to return a range from another worksheet then add to .To line in email

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 to use Evaluate for dates?

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

Pass a calculation with VBA from Access to Excel

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

Excel corrupting formula with @

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

Other Categories