All Tricks

This is archives page of Useful code. Currently the archives consist of 694 posts, 694 pages and 0 comments, with a total of 16 categories and 1 tags.

Tag Cloud

#name #num #ref () elements -1 .net .net core .Net Core SDK .Net notification icon .NET Standard 2d 2d array 3d 6 from 49 35% 70-483 80/20 with python 91-361 461 exam 483 1729 ABC Analysis django Abdulwahid Abdulhaque Barguzar Abstract Abstract Class Abstract classes abstraction Abstract Method access access time format Actions with dictionaries active sheet value ActiveWindow. ActiveX control picture from Excel Adam Freeman add a separate css to django add comment add css to django add data Add data to external files add element to div jQuery add file javascript adding columns add one value Add Shape add to json adodb Advanced Quantitative Finance Adventures of Computational Explorer Ajax alessandro molina algorihm algorithm Algorithm Challenge algorithm combination of coins Algorithms Algorithms with Excel algorithm test align all list Amazon and Deploy with Zappa Android Intents Angry Female GPS AngularJS Angular JS todo app Animate a ASCII picture in Console Animation of a line Anna Manning Apache POI API App Append appending files application Apress arg args arguments array arraylist Arrays AsciidocFX ascii picture console asking for password asp ASP.NET ASP.NET Core asp .net hello world ASP.NET MVC ASP.NET MVC with EF Core A Star Algorithm Excel A Star with Excel A Star with VBA Async Attributes audio Ausführung des Codes wurde unterbrochen AutoMacro AddIn automatic automation Automatization of Excel to HTML available code average distance dijkstra Avoid nested loops Azat Mardan azure azure app services Bad Programming Practices 101 Balancing CartPole with Machine Learning based on columns based on rows basic Basic Exam Basic Functions basic sql queries Bayes' theorem beautiful soup BeautifulSoup4 before sending mail Beginning SQL Queries benford Berlin best practise userform between characters between substrings bg coder bg_color Biggest Square in Matrix Biggest Triple binary digits count binary list usage binary operations binary search binary string binary tree from its leaves binary tree list binary tree list in python binary tree python Binding Binding of labels birthday paradox black Blockchain Basics blvitaca22 boilerplate book Book Review books Bootstrap bootstrap angular js scope bootstrap jQuery Borya's Diagnosis Bridges brute force bubble sort C# bug Build Build a binary tree list in python Build a Table building classes with C# Build simple sql function build simple sql procedure build table in html Bulk insert Bulls and Cows Business Intelligence Tools Business Intelligence Tools for Small Companies Buttons With Content button with context button with shape by ref by val C# C# 6.0 and the .Net 4.6 Framework C# algorithms C# algorithms Selection Sort C# binary search C# classes in VBA c# connect app to db C# Count Sort Algorithm C# Dictionary C# Dictionary Print C# Free Book C# Heap Sort C# interface c# library C# library in VBA C# library to a VBA project C# Linq C# lists C# OOP C# picture console C# picture in console C# sorting C# Sorting Algorithms C# squared root C# squared root binary search C# text masking C# TryGetValue C# tuple string integer C# UnitTests c# visual studio library c++ book calculate combinations calculating words in matrix Cartesian cartopy casino Cells center change and format index change cell values of merged cells change color Change Sheet Name VBA char in string vba chart chatGPT check Check Box List check if folder is empty Chong Lip Phang Cipher circle Clare Churcher classes Classes builders Classes in Python Classes in VBA classes with default procedure classes with default property Class Variable class with PHP clean c++ closed workbook closure code Code execution has been Interrupted code first codefirst codefoces codeforces Codeforces Round #402B CodeForces Round 368 code for creation of excel file with WPF CodeForeces Coding Tutorial coins collection in a dictionary Collection to Array color colorpicker Column Number to Letter combination Combinations combobox Combo Box Test command prompt comments compare floating point competitive programming composition computating column computation Computations compute_signature condition Conditional Compilation Arguments conditions Console Problems ConsoleWriteLine() constructive algorithms contest tasks Controls conversion of text array to integer array convert convert HH:MM:SS convert ToList() in one line Cookies in JS Coordiante system Coordinates Copy Excel worksheet copy object copy sheet copy worksheet core Core MVC Application Count count chars vba counter of elements Counter of Values in Array Countif Count the number of chars in a string Couples Frequency cramers rule crawler crazy Excel formula Create a complex create foreign key tables with sql create query create text file create trigger create two tables with sql Create Ul and LI elements with JS Creating Google Chrome Extensions creating triggers CRUD CRUD Functionality cryptography csv custom c++ function custom excel formulas custom formatting custom formula excel custom function custom function with vba Customization Customized Shortcut Custom SharePoint Solutions with HTML Custom Spell Checker custom VBA formula in Excel dan gookin Daniel Drescher Dashboards for Excel data analysis DataAnalysis data analysis excel database Databases for Small Business data entry dataframe DataScience Data scraping data scraping from internet data structures Data Transfer data validation Date and Time VBA Date Controls dates problem datetime day of the week formula debugging decimal declaration of variables decorator Decryption default argument default dictionary default list define class define date of the week define methods Defining Classes delegate c# delegate list c# delete delete all files from folder delete pictures delete rows delete shapes delete sheet delete worksheet Delphi deploy using local git deserialization determine odd devops DFS DFS algorithms dice dice algorithm dice calculation dice vba dict Dictionaries dictionary dictionary comprehension dictionary structure difference dijkstra dijkstra algo Dijkstra algorithm python dijkstra going a little crazy dijktra discount discount code display git log display links div/0 divisor of integer divisors vba django django girls dll docstring document.getElementById documentation Document with C# DOM dotnet summit dot product do while drawing drawing objects in VBA drawing with vectors dropdown Drop Down list dropdowns drug example Duggirala dunder duplicates dynamic dropdown Early and late binding early binding early binding dictionary edit comment edit data EF EF Core eggcellent eight ball eightball email verification Embedded Font Empty Code First model empty list Enable Migrations Visual Studio encoding encoding problems Encryption ensure_ascii Entity Framework EntityFramework entry field enum ENUM C# enumerate Enumeration environmental variables equal circle error error catching in unit test errors evaluate string event Event Objects events event triggers Exam exam 70-462 example example controls C# examples examples for jQuery in Ubuntu Exam Problem Excel Excel ActiveX Excel AddIns excel analysis Excel Application ExcelAutomation Excel Bulls and Cows Excel custom formula excel data analysis excel file creation Excel file generation excel find excel floating point excel formats problem excel formula excel formulas to values Excel Interop Excel Macro Mastery excel prime numbers Excel range to C# excel regression excel shortcuts excel simple linear regression excel speak excel speech excel stops excel to adoc excel vba Excel VBA 24-Hours Trainer Excel VBA: for Non-Programmers (Programming in Everyday Language) Excel VBA: How to Write Like a Professional Excel VBA Application Excel VBA A Star excel vba prime function excel vba prime numbers excel vba range excel worksheet to another workbook exception exe executemany exist existing Excel File Expandable Content Expandable Scrollable Content Expert Scripting and Automation explicit Export data from Excel to SQL Server with VBA Export data to SQL Server from Excel with VBA export table in html Extension Methods External files in excel Extracting text from string between two identical characters extract links to file Fast Operation fetch_arrays fetch_fields fibonacci file log file path reduction Filter filtered filtered text filtering filter values from dataframe find find function find substrings first column and first row of Excel is with index 0 First Day At School Flask float pointing arithmetics Flow Document FlowParagraph Following in GitHub font_color ForEach Forecasting forecasting excel Foreign Keys Foreign Keys in Entity Framework foreign library VBA for loop vba format format html with javascript format text in cell formatting forms Formula Formulas fraud detection Free Excel Book Free Programming Book from cell from internet from text file from variable from XML to HTML Full Stack JavaScript function function calling function function of function function returning function functions in javascript gadgets Gale Gale–Shapley Game of rows Gdi Text Rendering generate data Generate data in table MS SQL generate numbers per column generate sql script generate sql script from a db Generating column names from number Generation of Random Text JS GET get column of 2d array Get data get data into table GetEnumNames get first column get first row get index match on multiple columns get json get JSON data from files getNamedItem getpass get schema and data sql script Get started Get the First SubString Getting data from a database Getting Elements by Tag Name ghost breaks Git GitHub Global Variables go golang Goldmeier google api Google API book google maps google maps api Google Maps Coordinates google maps java script Google Maps JavaScript API Cookbook Grant Fritchey Graphical Tab Titles greed greedy greedy algorithm green HackBulgaria half border Handle concurrency - ASP.NET handling hashing Hashing Passwords hashlib heapify heapq Heap Sort Algorithm heat maps help HH:MM:SS from Minutes hide named range hide worksheets history hmac HMACSHA1 how how to access microsoft certificate how to add css to python how to animate a line in google maps how to install python how to print ms certificate how to start how to vbscript HTA HTA Example HTA VB HTA VBA HTML HTML5 Games Development by Example HTML Application html export HTML Games html table export vba html tags icpc if iframe in jquery iframe in table ignore list ignore values iif Image List image to div jQuery implementation Implementing Inheritance implements Import data from Excel to SQL Server with VBA Import data to SQL Server from Excel with VBA Indeterminate Progress Bar index(match) inheritance Inheritance C# init class input Insert Before insertion sort Insert picture excel insert variables in string install C# for ubuntu install monodevelop for mint install monodevelop for ubuntu install monodevelop in Linux Instance Variables interface internet internet from excel Interop.Excel intersection introduction iteration iterator with php it olympiad jaavscript oop japikse Jason Lengstorf Java Java Compiler to Exe Java Game with code Java problem Java Script javascript JavaScript button selector JavaScript cookies javascript dictionary JavaScript Frameworks for Modern Web Dev java script google java script google API Java script google coordinates javascript inheritance JavaScript Object Programming javascript oop javascript prototype Java Script Recipies javascript sort dictionary Java Snake Join to collection jQuery jQuery Add And Remove to list jquery animation jQuery background jQuery button selector jquery class jQuery events jQuery forms jQuery forms automatization jquery id jquery iframe in table JQuery links jQuery mobile jQuery random jQuery serialize jquery simple game jquery slidetoggle js JS input fields JSON json.dump json.dumps JSON encode Ajax json in table json load from file json save file json search js pictures js todo app Jupyter Jupyter Notebook Kaspichania Boats Keith Cirkel Keith Wald KI knight's tour kwargs label Label Test lambda last cell in column last cell in row last cell value Last Column Last Row last used cell Last Used Column Excel Last Used Row in Excel LastUsedRow LocateValueRow Last Value in Column Last Value in Row late binding lbound Learning Android Intents Learn PHP7 len letter to column number level levels of logging library like in excel like in vba linear algebra linear equations linear regression linear regression python Link linkedList links LINQ LinqPad List list append python listbox list comprehension ListCount list extend python Listing all procedures in all modules List of int and string with tuple ListOfLists in Python lists list to dictionary in python list to int python list to string python LiveCoding live coding live coding video loading data to a dataframe load page from excel load web page LocalFormula locate locate a value in a row LocateValueCol locking cells with vba log log file logger logging logging to a file logging to console Logical Scrolling log sheet Longest longest increasing sub sequence Longest Odd Even Sequence Longest Palindromic Substring longest sub sequence excel longest symmetric factor look at values loop loops Loop shapes in slide loop through files LoopThroughLines lottery numbers lotto lotto simulator Maayan Poleg Machine Learning Summit Macro Recording in Excel magic square magic squire python mailing attachment mailing range mails Make a scope with AngulaJS make comments float makeovermonday make pdf with php Making Excel looking good manning many to many relationship query Map Map and Reduce Markov Markov Model Markov Probability Martin Rinehart Masking words in C# Mastering Concurrency in Python Mastering Large Datasets Mathieu Guindon math operations matplotlib matrix matrix calculation python matrix comprehension matrix diagonals maximum length contiguous substring mcp mcsa mean excel Meller watch memoization merge cells with equal values MessageBox for a Change Message Box for a Change Messi vs Ronaldo Methods microsoft Microsoft SQL Server Management Studio Create View mid Migrations minimizing Miss Cat 2011 ML Model First Modern Python Standard Library Cookbook module for buttons module in JS monodevelop install month name MonthName MonthNumber moscow workshops mousemovements in .Net mouseover ms access ms access vba msoConnectorStraight MS SQL Server multidimensional array MultiDirectional Expanders multiple criteria multiple sheets multiple tabs Multiple Tabs color multiset MVC MVC Web MVC with EF Core MySql mySql excel mySQL for excel MZ tools named range name to number Natural order sequences negative array index python nested dictionary Nested Lists C# NetworkDays node js noise non latin variables normal circle not returning first value number Numerically NumPy NumPy for Simulations Oasis SVN odd numbers offset onclick button js oneline oop oop js oop with javascript Openpyxl option optional parameters vba option compare binary option compare text ordered dictionary outlook output output file overload Package Manager Console Packt Publishing paging palindrome Palindromic Pandas parameters parameters in vba Paretto with Python parsing pdf perfect userform perlin noise permutation permutations Peter A. Carter Peter Ritchie PHP php build standard html table php cookies php file html table php iterator PHP XML picture picture in ActiveX control Pivot Tables Pixi.js book pixi js pixi js game Plane plotting plotting both predicted and real values plotting data in matplotlib Plotting with Object-Oriented API populate data with vba Popup Text position correctly POST postman PowerPoint Practical Microsoft Visual Studio 2015 Prateek Mehta prediction prefill PrependTo prime number function prime numbers print dictionary Printing a matrix print links print nested dictionary print shortest path dijkstra Pro ASP.NET Core MVC 2 Probability Simulation probability simulator Problem 3 – Plane Procedures product Properties pro php and jquery Pro SQL Server Administration ps put PyLab Python Python 3 python3.4 reading files Python Algorithm Book python algorithm dijkstra python algorithms python algoritm sorting Python book Python classes python console reading arguments python data analyitcs Python Data Analytics python diagonals matrix python function Python Functions From Excel python in excel python insertion sort Python JSON files python list python list sort python matrix python stable matching Python Summit python tuples python vba python with sqlite3 Quan Nguyen query query language QueryTables.Add query with C# query with csv files queue Radio Button Groups random random colors jQuery random noise random numbers jQuery range Range.Find() range function range minimal query Range object Ranges range to array Read read 3 variables read all read file javascript Read From Excel Async reading reading arguments from console reading data reading files reading from php file reading from table read range Read related data recursion red red and black redirect Reduce refactoring reflection regex RegEx generator javascript regex in excel RegEx tool regex vba regression data analysis Relational Database Programming remove remove characters with string vba remove duplicates remove empty elements from array RemoveItem remove lines remove none remove reference remove spaces rename repr Requests Library requirements.txt reshape resource reveal password in chrome Reveal Triangles reverse array sorting reverse colors in excel reverse sorting java reverse words Review reviews reviews of gadgets rotate run-time 1004 run-time 1004: Method 'Range' of object '_Worksheet' failed Run Java Script in Sublime Text running Runtime Binding runtime error 1004 Russ Ferguson s sample save diagram as gif Save Diagram as picture save excel file save text save worksheets to csv Scraping Scraping web site scripting.dictionary scripting runtime Scrollable Text Box Column search search and highlight search in a log Search in worksheet second biggest value secure adodb select data from a dataframe Select first child jquery select last child Select Multiple Cells select nth child selectors jquery send mails with python server set cookies in PHP SET IDENTITY INSERT MS SQL SET IDENTITY INSERT OFF Set IDENTITY INSERT ON set list as a VBA parameter sets Settings setup setup jQuery from scratch setup jQuery in Ubuntu Setup jQuery project with node.js Sha1 Shapley shell shift shifting column Shortcut shortcuts shortener shortest path short variable declaration vba show all links show only active worksheet Sieve of Eratosthenes simple Simple Ajax example simple application Simple Calculator Simple Django App Simple Example for Transaction simple interface with classes simple jquery site simple mvc simple oop simple PHP simple snake simple wpf application Simulating stock returns simulation simulator singlenode slice notation slicing Sliders Compared Slider Test Small Smart Data Analysis Smart Indent smtplib python smtplib send mails snake snake C# snake game SoftUni Software Architecture Software documentation software review software vba solution of a system sort sort array sorting sorting vba array Source Control special position specific specific vba error handling split countries Split string Split String in One Line split worksheet to worksheets sql sql alchemy sql alchemy python commands sql alchemy python select sql alchmey create a table sql ALTER table SQL Create View sql data below average sql embedded queries sql exam SQL Functions sqlite3 sql left or right join SqlLite3 sql queries sql query excel SQL Server sql server conditional sql server create trigger sql server if sql server join sql server log sql server log changes sql server multiple foreign keys SQL Server Object Explorer SQL Server Query Performance Tuning SQL Server Transaction SQL Transaction Example Simple stable matching stable matching algorithm stable matching problem Stack standard error excel statistics statsmodels Step-by-step Stephan Roth Stephen Wolfram Steve Prettyman str stream handler strftime string string between 2 strings string between strings String Counter string format string instr StringReverse string slicing string to int string to list of int strip a string StrReverse Style styles sublime text subsequence substring Substring Between 2 Substrings substring search Sumif Sumifs summing columns to a new column SumOfCards Sumproduct sum values in excel Sum with Array symmetric difference Synchronization of google maps System.Collections.ArrayList tableau table export vba take list as argument of function C# taxicab number TDD teardown teasing small game in .Net Telerik Telerik Contest terminal Test testcoverage Tests tetrahydron calculation TextBox Text Box Test that cannot be updated the beauty the geek and the all-mighty pig the horror The Python Workbook threads tika timedelta TimeSpan tiny c projects to do app with javascript todo list todo list with .net to excel cells Tooltips Too many different cell formats top50 Bulgarian sites top servers worldwide Transition Probability Matrix transpose Trigger TriggerHandler trim troelsen true negative true positive tutorial two dice simulation vba Type Declaration Suffixes type error unit test ubound Ubuntu Ubuntu install mono Ubuntu setup jQuery Ubuntu terminal commands UDF ultimate review team unhide comments union union range unittest UnitTesting UnitTests unlocking cells with VBA unlock xlsb file vba unlock xlsm file vba unviewable updatable list update update json in node js Update related data Upload an image url Urls usage of checkmarks Usage of classes usage of column names for formulas User Defined Function user defined types userform Vanya and Label Variable variable dropdown variable list variables various countries VAT Calculation VAT calculation formula VB VB .NET vb .net todo VBA vba addin vba addins vba algorithms VBA bulls and cows vba by value vba cells vba change font vba change font word VBA class VBA classes vba class modules VBA collection for-each VBA Collections VBA Color Change VBA Colour Change vba count vba custom formula VBA custom formula parameter list vbadiff vbadiff review vba divisors functions VBA e-mail from Excel vba errors VBA Excel vba excel creator VBA Excel Loan Payment Calculator vba export table VBA Formating vba function divisors vba immediate window vba insert string in string VBA library vba online resources vba password protect vba predefined code vba prime numbers vba range vba shortcuts vba shortcuts comments VBA simulation vba tools VBA Upper Case VBA Upper Case Automatic vba word vba word tricks vbe vbscript vbWatchdog verbose verbosity verify a message integrity verifying files integrity Video Video course Learning MongoDB Video course Review video review View Views Virtual Environment visiblilty named range visualization visual studio Visual Studio 2019 visual studio shortcuts won a raspberry pi 2 vlookup vlookup multiple range voice control vs vue watchdog watch window Web web api Web App Web Coding Bible Web crawler web site weeday while do why byref byval window.addEventListenerm Windows Wine Glass Wingdings 2 wing ide review withevents with events visual basic without console without reference without VBA words from file in python workbook workbook to csv working with numbers worksheetfunction.trim WPF wpf application wpf c# wpf styles Write Write to Excel write to file Write Values in Worksheets writing algorithm Writing data writing files Writing in the Console writing to a database writing unit tests XAML XlsWriter xlsxwriter xml xml php links XML with VB xUnit youtube

Last 1000 Posts


Monthly Archives