Top "Excel" questions

Only for questions on programming against Excel objects or files, or complex formula development.

Excel VBA - exit for loop

I would like to exit my for loop when a condition inside is met. How could I exit my for …

excel vba for-loop
How to keep one variable constant with other one changing with row in excel

Lets say I have one cell A1, which I want to keep constant in a calculation. For example, I want …

excel excel-formula
Copy Paste Values only( xlPasteValues )

I'm trying to copy entire column in sheetA to Sheet B. sheetA column has values formed with formuls. I'm copying …

excel vba copy-paste
Excel to CSV with UTF8 encoding

I have an Excel file that has some Spanish characters (tildes, etc.) that I need to convert to a CSV …

excel encoding csv utf-8
Check if Cell value exists in Column, and then get the value of the NEXT Cell

After checking if a cell value exists in a column, I need to get the value of the cell next …

How to read and write excel file

I want to read and write an Excel file from Java with 3 columns and N rows, printing one string in …

java excel
How to activate a specific worksheet in Excel?

I just need to activate a certain worksheet. I have a string variable that keeps the name of the worksheet.

excel vba
How to pause for specific amount of time? (Excel/VBA)

I have an Excel worksheet that has the following macro. I'd like to loop it every second but danged if …

excel vba
Return empty cell from formula in Excel

I need to return an empty cell from an Excel formula, but it appears that Excel treats an empty string …

excel excel-formula
How to get the path of current worksheet in VBA?

I wrote a macro as an add-in, and I need to get the path of the current worksheet on which …

excel vba