Excel – Allow Certain Users to Edit Cells Range

Excel offers you an ability to assign user-level permissions to different areas on a protected spreadsheet. You can specify which users (usually local or Active Directory ones) can edit a particular range while the spreadsheet is protected. Read More …

Copy values-formatting from a range to another (Excel)

In Excel, copy values and formatting only can do as follows: Select the range you want to copy. Click Edit Read More …

Block IP ranges in Windows Firewall

Send Us a Sign! (Contact Us!) Show More Info This article has total words. (Including header) If you are using Read More …

Evaluate value between numbers (Excel)

Send Us a Sign! (Contact Us!) Show More Info This article has total words. (Including header) Generic formula =AND(val>MIN(num1,num2),val<max (num1,num2)) Read More …

Excel – Formula to check if cell contains specific string

=ISNUMBER(SEARCH(substring,text)) If you need to check if a cell contains a substring (specific text), you can do so with the Read More …

Generate Random Numbers In Python

Python includes a standard library to generate random numbers. This library is called “random”. In order to start generating random Read More …

Redirect con htaccess tramite indirizzo IP

A volte può capitare di dover vietare l’accesso al proprio sito web, per manutenzione o per altri motivi, oppure abilitare Read More …

20 ways to Optimize VBA Code for FASTER Macros

This article contains both the knowledge and good practices which if followed and used effectively then it might put you Read More …