Entries Tagged 'Programming(Web etc)' ↓

INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from)

Excel INDIRECT function – basic uses and formula examples (ablebits.com)

Benefit for learning VBA

Unlike macros, VBA enables you to do the following:

  • Work with complex logic structures (case statements, loops, and so on)
  • Take advantage of functions and actions not available in macros
  • Loop through and perform actions on recordsets
  • Perform transaction processing


The ParamArray keyword allows you to accept a dynamic number of arguments.
The word ParamArray is an abbreviation for parameter array.
Instead of using a large number of optional parameters it might be better to use a parameter array instead.…

Python for Machine Learning: Indexing and Slicing for Lists, Tuples, Strings, and other Sequential Types

List is arguably the most useful and ubiquitous type in Python. One of the reasons it’s so handy is Python slice notation. In short, slicing is a flexible tool to build new lists out of an existing list.

Python supports …

Cool Javascript Find on this Page…


jQuery: fire click() before blur() event

Solution 1

Listen to mousedown instead of click.

The mousedown and blur events occur one after another when you press the mouse button, but click only occurs when you release it.

Solution 2

You can preventDefault() in mousedown to …

Sortable — is a JavaScript library for reorderable drag-and-drop lists on modern browsers and touch devices. No jQuery. Supports Meteor, AngularJS, React, Polymer, Knockout and any CSS library, e.g. Bootstrap.


Reorder list using jQuery and ASP.NET http://sumo.ly/9Lu4 via @CodeAspNet


Bootstrap Multiple Select (Multi-Select) DropDownList with CheckBoxes in ASP.Net MVC Razor


Play Sounds in Websites