Excel consultant Ketil Øyesvold Melhus
I am a psychotherapist and system developer – where the common denominator for the two professions is diagnostics.
Similar Posts
Multi Language Excel Invoice Template
Beware this is an unfinished project – and you are free to finish it. If you are looking for a out of the box invoice program, don’t download it – it’s not fully quality tested. If you are a VBA-developer, feel free and share your modifications with me. No, sorry, it doesn’t work on MAC…
Function ffC() – Find first free column in first row
Usage example Function Code The function ffC is part of My Common Library:
Excel VBA: Working with shapes and Pythagoras
This was a fun exercise. How to place a random number of dots on a circles circumference with exact the same distance between them? The need arose building a program for automated seating. Rectangular tables were no big deal, but what about the round tables? You can download the workbook at the bottom of this…
Hour registration in Excel with calculation of time within intervals
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…
Excel VBA: Subroutines for speed optimization
Sub AppOnOff Sub AppEv Sub AppCal Sub AppSc You can download the Excel workbook with the sample code at the end of this Article Sub AppOnOff AppOnOff true – turns off Events, Automatic Calculations and ScreenupdatingAppOnOff false – turns them back on AppEv, AppCal and AppSc turns Events, Automatic Calculations and Screenupdating on/off individually When…
Function ffR() – Find First Free Row
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…