Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Excel code to turn the filter on and off after a cell Office-365/Excel/Code-vba-Makro
Excel code to turn the filter on and off after a cell
09.10.2021 41
Small Excel macro, with which you can automatically filter for the active cell via keyboard To do this, simply copy the code into the staff Step 1: Alt+F11 ->vba Code Step 2: Left pane Project >VBAProject (PERSONAL XLSB) Step 3: Co

Format Excel Data as Data Bars Office-365/Excel/Tutorials
Format Excel Data as Data Bars
13.07.2021 205
Setting Excel Data Bars If you want to display values as data bars in Excel, you can create this function with menu > Conditional Formatting The easiest way is to select directly in the drop-down selection: Data bar >Colored fill and then Red data bar as the

Excel Macro Code: Divide text into columns with a maximum of 132 characters Office-365/Excel/Code-vba-Makro
Excel Macro Code: Divide text into columns with a maximum of 132 characters
08.04.2021 473
Excel Macro: Divide text into columns with a maximum of 132 characters, where words must not be separated Option

Excel template: Calculate frequency and capacity from LC swing circuit Office-365/Excel/Templates
Excel template: Calculate frequency and capacity from LC swing circuit
18.03.2021 314
In this Excel template you can calculate the required inductance, capacity or the resulting frequency from an LC swinging circuit

Errorcode 450 Using Email.Session.Accounts Email_From Office-365/Excel/Code-vba-Makro
Errorcode 450 Using Email.Session.Accounts Email_From
16.11.2020 724
Code 450: For the user of the code: objEmail Session Accounts(sEmail_From) Error: 450 Description : "Incorrect number of arguments or invalid assignment to a property" : String : modEmail Send_Email_to_Address Solution: 1) enter eithe

Open and Read a Word File with Excel Office-365/Excel/Code-vba-Makro
Open and Read a Word File with Excel
06.11.2020 550
Vba Code Beispiel: mit Excel ein Word Dokument lesen In Word Makro ist der Code : Dim app_Word As New Word Application Dim doc As Word Document Set doc = app_Word Documents Open (sWord_Filepath, ReadOnly:=True, Visible:=False) doc Content Cop

Excel: REwrite RTF to HTML Office-365/Excel/Code-vba-Makro
Excel: REwrite RTF to HTML
23.04.2020 1068
The following format enumerations are used to convert characters to HTML in RTF: In case of double underlines XlUnderlineStyle: xlUnderlineStyleDouble -4119 Double fat underline xlUnderlineStyleDoubleAcco

Excel Instructions: Remove Duplicate Rows, Remove Duplicates Office-365/Excel/Tutorials
Excel Instructions: Remove Duplicate Rows, Remove Duplicates
22.04.2020 928
Remove duplicate rows , remove duplicates To remove duplicate rows or unnecessary lines: You select a range or table in Excel Then Excel->Menu-> Data -> Remove duplicates Then you can select the columns after which you want

Excel grouping from top to bottom Office-365/Excel/Tutorials
Excel grouping from top to bottom
02.03.2020 1049
Excel grouping from top to bottom How to flip the grouping sign from bottom to top in Excel when opening in standard mode excel displays the grouping character below the grouping In theclosed state, the grouping character is below the hidden area

Excel: Convert numbers, date and time to text Office-365/Excel/Code-vba-Makro
Excel: Convert numbers, date and time to text
14.01.2020 1216
How to convert entire columns or ranges in Excel from numbers, date or time format to real text

Mobile

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de