Random codes

Similar codes

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

ANmarAmdeen

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

ANmarAmdeen

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

2019Feb8

ANmarAmdeen

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

ANmarAmdeen

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

ANmarAmdeen

Modal form open Workbook

Do not open workbook from userform after .show

Aug3

ANmarAmdeen

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

ANmarAmdeen

GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

2018Jun22

ANmarAmdeen

GetUTC

Get the time and date in Universal time based on local time Uses w32tm / tz ...

2018Jun22

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

ANmarAmdeen

CutString11

Cuts long string from certain character to certain character with option to ...

Feb24

ANmarAmdeen

JQMeter

A progressbar (or meter) in JQuery, customized with nice options

2019Feb3

ANmarAmdeen

This Year

A quick JS way to get the year of today, a method found it online, and wanted ...

2018Dec16

ANmarAmdeen

Hex2Int

Converts hex to Integer

2018Sep27

ANmarAmdeen