Codes Required
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
RowsCount
Get total number of rows for a certain worksheet in certain workbook workbook ...
2018Jun22
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Similar codes
PrCal_Add_Sort
Adds to daily log, two cells, one with date, next with activity that will be ...
Dec2
LogFile_Add
Adds an entry to log file, if file is not exist, it will be created. Filename ...
2018Jul17
Create and Write Log File
The subprocedure can be called by any ASP applicaiton/page which needs to ...
2018Apr14
LogoutALL
Logs out Linkedin by running two commands One will open new window to logout ...
2018Apr23
ANmaRedirect_Plus1
Function to log the redirects that happen into website It is merely used with ...
2019Oct25
Auth_User
Find the user name (and domain) for logged in user for in an internal intranet ...
2020Feb23
Add2Column
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
UserChanged_Log4
Adds date to column1 when user enters text in column2. Also, if user remove ...
Nov28
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
Refresh HTML page + Go Back
HTML Javascripts to refresh page And another line to go back to previous page. ...
2020Sep7
Posts per year-month
Create summary list If you have SQL table named Messages, with DateStamp ...
2018Dec15
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
DB_Setting2Read + DB_Setting2Save
Reads and save setting into settings table per 2 IDs, similar to SettingRead ...
2018May31