Codes Required
Similar codes
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
SheetName
Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...
2018Aug23
List_of_Names + DeleteNames
List names in a certain workbook into sheet. And Deletes those names. You may ...
Jul9
WorkbookClose_ANmar
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
Generate_PowerPoint
Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...
2020Dec22
Excel sheet textbox
Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...
2020Feb22
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
BrowseImage
Asks user to select an image and returns full path and name of selected image ...
2020Dec19
Javascript Analog Clock
AN analog clock in js
From
2019Jul15
ServerUptime
Return how long the computer has been running. Return format is dd:hh:mm:ss ...
2018Jul11
