Random codes

Codes Required

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

Similar codes

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

ANmarAmdeen

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

ANmarAmdeen

FindSheet

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

2018Jun7

ANmarAmdeen

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

Jul24

ANmarAmdeen

SheetAdd_ANmar

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

2019Apr1

ANmarAmdeen

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

Nov22

ANmarAmdeen

List_of_Names + DeleteNames

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

Jul9

ANmarAmdeen

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

ANmarAmdeen

Excel user name

Get application user name or change it Originally from

Jun14

ANmarAmdeen

Recently by developer

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

ANmarAmdeen

Files_FoundHours

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

Tue 7AM

ANmarAmdeen

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 ...

Apr23

ANmarAmdeen

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

Dec21

ANmarAmdeen

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

Sep3

ANmarAmdeen

blueimp Gallery

Touch-enabled, responsive and customizable image and video gallery, carousel ...

Aug16

ANmarAmdeen

Create and Write Log File

The subprocedure can be called by any ASP applicaiton/page which needs to ...

2018Apr14

PavGill