Similar codes
Vertical page breaks
Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...
2021Feb24
WelcomeSheet
A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...
2018Jul9
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Excel recovered files
Location of Excel recovery workbooks in your system when Excel crashes, it ...
2023Mar31
Execute exe embedded in Excel
Execute exe file that embed inside Excel sheet This is for experimental, not ...
2021Apr16
Excel sheet textbox
Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...
2020Feb22
Styles_DeleteNonStandard
Delete styles from an Excel workbook, any non-standard style will be deleted. ...
2018Aug12
RunFromShared
Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...
2018Aug9
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
Int function in ASP Classic (cint vs fix)
If you are looking for a function ASP Classic (VBScript) to do what Int() does ...
Feb6
DB_SettingRead_Field
Returns a certain field from Settings table by a SettingName. Similar to ...
2018Jul24
GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_
Gets that parent folder name giving a full path, or gets the child folder, Can ...
2018May22