Random codes

Codes Required

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

ANmarAmdeen

FindFile_Word

Finds a file within open documents of current instance

2018Aug9

ANmarAmdeen

FindFile

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

2018Jul11

ANmarAmdeen

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

ANmarAmdeen

Similar codes

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

ANmarAmdeen

WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

2018Aug9

ANmarAmdeen

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

ANmarAmdeen

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

Aug9

ANmarAmdeen

ConcaUFO_RowsfromSheets

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

2020Nov11

ANmarAmdeen

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Dec22

ANmarAmdeen

FindFile

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

2018Jul11

ANmarAmdeen

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

ANmarAmdeen

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

Jul9

ANmarAmdeen

Recently by developer

MatchIf2Up

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

Mon 9AM

ANmarAmdeen

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Tue 8AM

ANmarAmdeen

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

ANmarAmdeen

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

ANmarAmdeen

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Jan15

ANmarAmdeen

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14

ANmarAmdeen

Card5-BS3

Cards in Bootstrap 3, nice and smooth

2019Apr7

ANmarAmdeen

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

ANmarAmdeen