All Tricks

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

Tag Cloud

#name #num #ref () elements -1 .net .net core .Net Core SDK .Net notification icon .NET Standard 2d array 6 from 49 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 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 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 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 Blockchain Basics boilerplate Book Review Bootstrap bootstrap angular js scope bootstrap jQuery Borya's Diagnosis Bridges brute force bubble sort C# 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 Check Box List check if folder is empty Chong Lip Phang Cipher 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 codefirst code first codefoces codeforces Codeforces Round #402B CodeForces Round 368 code for creation of excel file with WPF CodeForeces coins collection in a dictionary Collection to Array color colorpicker Column Number to Letter combination Combinations combobox Combo Box Test command prompt compare floating point competitive programming 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 Values in Array Countif Count the number of chars in a string Couples Frequency 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 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 Daniel Drescher Dashboards for Excel data analysis data analysis excel database Databases for Small Business data entry dataframe Data scraping data scraping from internet data structures Data Transfer data validation Date and Time VBA Date Controls dates problem day of the week formula debugging decimal declaration of variables decorator Decryption default dictionary define class define date of the week define methods Defining Classes delegate c# delegate list c# delete all files from folder delete pictures delete rows delete shapes delete sheet delete worksheet Delphi 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 display links div/0 divisor of integer divisors vba django django girls dll document.getElementById Document with C# DOM dotnet summit drawing drawing objects in VBA 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 Enable Migrations Visual Studio encoding encoding problems Encryption ensure_ascii Entity Framework EntityFramework entry field ENUM C# Enumeration environmental variables 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 AddIns excel analysis Excel Application 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 existing Excel File Expandable Content Expandable Scrollable Content Expert Scripting and Automation 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 text filtering find find function 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 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 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 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 HackBulgaria half border Handle concurrency - ASP.NET handling hashing Hashing Passwords hashlib Heap Sort Algorithm heat maps HH:MM:SS from Minutes hide named range hide worksheets history hmac HMACSHA1 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# 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 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 javascript Java Script 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 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 library like in excel like in vba 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 live coding LiveCoding live coding video loading data to a dataframe load page from excel load web page LocalFormula locate a value in a row LocateValueCol locking cells with vba log file logger 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 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 matrix matrix calculation python matrix comprehension matrix diagonals maximum length contiguous substring mcp mcsa mean excel Meller watch memoization merge cells with equal values Message Box for a Change MessageBox for a Change Messi vs Ronaldo Methods microsoft Microsoft SQL Server Management Studio Create View 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 Tabs color 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 non latin variables not returning first value number Numerically NumPy NumPy for Simulations Oasis SVN odd numbers offset onclick button js oop oop js oop with javascript optional parameters vba outlook output file overload Package Manager Console Packt Publishing paging palindrome Palindromic Pandas parameters parameters in vba Paretto with Python perfect userform 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 PowerPoint Practical Microsoft Visual Studio 2015 Prateek Mehta prediction prefill PrependTo prime number function prime numbers 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 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 Functions From 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 numbers jQuery range Range.Find() range function range minimal query Range object Ranges range to array read file javascript Read From Excel Async reading arguments from console reading data reading from php file reading from table read range Read related data recursion red and black 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 reference rename repr Requests Library requirements.txt reshape 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 Runtime Binding runtime error 1004 Russ Ferguson s sample save diagram as gif Save Diagram as picture save excel file save text Scraping Scraping web site scripting.dictionary scripting runtime Scrollable Text Box Column search search and highlight 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 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 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 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 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 string 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 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 Tests tetrahydron calculation Text Box Test that cannot be updated the beauty the geek and the all-mighty pig the horror The Python Workbook threads TimeSpan 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 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 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 watchdog watch window Web web api Web App Web Coding Bible Web crawler web site weeday 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 working with numbers worksheetfunction.trim WPF wpf application wpf c# wpf styles Write to Excel write to file Write Values in Worksheets writing algorithm Writing data 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