Open large CSV in Excel

Excel contains over one million rows – 1,048,576 to be exact. If your file is larger than that and you will try to…

Posted On

Milliseconds in Excel

A millisecond is a one-thousandth of a second. Normally when you work with Excel, you need Dates and Time with hours and minutes,…

Posted On

VBA range.rows

The Rows property represents all the rows on the specified worksheet or range. We are going to use the following example. Each cell…

Posted On

VBA range.row

The Range.Row property returns the number of the first row in the selected range. To illustrate you this we are going to select…

Posted On

Unshare Excel file

After you worked with the members of your team, at some point you may want to restrict access to selected files that other…

Posted On