Only for questions on programming against Excel objects or files, or complex formula development.
I would like to exit my for loop when a condition inside is met. How could I exit my for …
excel vba for-loopLets say I have one cell A1, which I want to keep constant in a calculation. For example, I want …
excel excel-formulaI'm trying to copy entire column in sheetA to Sheet B. sheetA column has values formed with formuls. I'm copying …
excel vba copy-pasteAfter checking if a cell value exists in a column, I need to get the value of the cell next …
excelI want to read and write an Excel file from Java with 3 columns and N rows, printing one string in …
java excelI just need to activate a certain worksheet. I have a string variable that keeps the name of the worksheet.
excel vbaI have an Excel worksheet that has the following macro. I'd like to loop it every second but danged if …
excel vbaI need to return an empty cell from an Excel formula, but it appears that Excel treats an empty string …
excel excel-formulaI wrote a macro as an add-in, and I need to get the path of the current worksheet on which …
excel vba