Error in finding last used cell in Excel with VBA
When I want to find the last used cell value, I use: Dim LastRow As Long LastRow = Range(“E4:E48”).End(xlDown).Row Debug.Print LastRow I’m getting … Read more
excel
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 each cell. … Read more
How to correctly display .csv files within Excel 2013?
It seems Excel 2013 doesn’t read CSV files correctly (Excel 2010 does). Every time I open .csv files, all my data are displayed … Read more
Microsoft Excel mangles Diacritics in .csv files?
I am programmatically exporting data (using PHP 5.2) into a .csv test file. Example data: Numéro 1 (note the accented e). The data … Read more
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 to calculate a … Read more
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 loop when the … Read more
Saving results with headers in SQL Server Management Studio
I am using SQL Server Management Studio. I wish to save the results of a query to an excel file. I choose “save … Read more
Excel: last character/string match in a string
Is there an efficient way to identify the last character/string match in a string using base functions? I.e. not the last character/string of … Read more
What is the difference between .text, .value, and .value2?
What is the difference between .text, .value, and .value2? Such as when should target.text, target.value, and target.value2 be used? 7 Answers 7
Reading Excel files from C#
Locked. This question and its answers are locked because the question is off-topic but has historical significance. It is not currently accepting new … Read more