Excel consultant Ketil Øyesvold Melhus
I am a psychotherapist and system developer – where the common denominator for the two professions is diagnostics.
I am a psychotherapist and system developer – where the common denominator for the two professions is diagnostics.
When I want to add a new record to a table, I use the function CurrentRegion.Rows.Count and add 1 to the result to find the first empty row.CurrentRegion returns the contiguous range from a spesific cell. The contiguous range is the range from A1 in the case below – with no empty rows. Selecting CurrentRegion…
If you work from 20:15 to 02:30 on a Saturday, how many hours are in the interval 15:30 to 00:00, and what should you be paid? The function HoursInInterval() can give you the answer and calculate your wage correct depending on it’s a weekday, weekend or a holiday. You can download the workbook at the…
RunCopyUsedRangeValues will copy the values from the sheet with codename shSource to shDestination. It is extremely fast, and very useful when I don’t need formatting or formulas. You can download the Excel workbook at the bottom of the article Usage example The source and destination sheets can be in the same or in separate workbooks…
With the Sub UpdateAppointment you can create and update Outlook meetings or appointments. All items must have a unique index to filter on. The sub filters on BillingInformation, a field I rarely use for other purposes. Appointments The appointments are created in your personal calendar. If you want to put stuff in others calendar, you…
Find content in column1 with header xx, return value from same row in column2 with header yy. Note The function returns 0 (Zero) when value isn’t found, so you will not be able to distinguish between a found zero value, and value not found. So do not use if you have zero values in your…
Usage example Function Code The function ffC is part of My Common Library: