Similar codes

Card image cap
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

Card image cap
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

Card image cap
MatchIf2Up

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

Mon 9AM

Card image cap
DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Card image cap
CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1

Card image cap
KillFile

Deletes a file, using mapped or unmapped file path

2018Apr21

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Card image cap
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

Card image cap
SheetDelete_ANmar

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

2018Aug9

Recently by developer

Card image cap
MatchIf2Up

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

Mon 9AM

Card image cap
ANString_Location

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

Tue 8AM

Card image cap
SettingSave + SettingRead for NumberFormat

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

Apr19

Card image cap
ANmaCellFormat

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

Apr18

Random Codes

Card image cap
Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

Jul25

Card image cap
AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Card image cap
Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7