Excel consultant Ketil Øyesvold Melhus
I am a psychotherapist and system developer – where the common denominator for the two professions is diagnostics.
Similar Posts
Excel VBA: CopyUsedRangeValues – fastest way to copy values from sheet to sheet.
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…
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…
Excel VBA – Create and update Outlook Calendar Items
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…
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 fR() – Return row number where Content is found in Column with specified Header
Usage example Video sample Function code The function fR is part of My Common Library: My Common Library (1 download)
Excel VBA: Create a series of workdays only
The Nextworkday(date, optional holidays) function returns the date for the next workday. The first parameter is the starting date you set manually.The second parameter is optional and points to a range with dates you want to exclude from the workdays list, like easter or your vacation.If you omit the second parameter, only Saturdays and Sundays…