excel Archives - IT Nursery

excel, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

excel, Programming

IT Nursery

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 ...

June 1, 2022
0 Comments

excel, Programming

IT Nursery

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 ...

June 1, 2022
0 Comments

excel, Programming

IT Nursery

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 ...

June 1, 2022
0 Comments

excel, Programming

IT Nursery

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 ...

June 1, 2022
0 Comments

excel, Programming

IT Nursery

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 ...

May 29, 2022
0 Comments

excel, Programming

IT Nursery

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

May 28, 2022
0 Comments

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 or a reference ...

May 23, 2022
0 Comments

Check whether a cell contains a substring

Is there an in-built function to check if a cell contains a given character/substring? It would mean you can apply textual functions like ...

May 23, 2022
0 Comments

Loop through files in a folder using VBA?

I would like to loop through the files of a directory using vba in Excel 2010. In the loop, I will need: the ...

May 21, 2022
0 Comments