Search results 20

Sorted from new to old.

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

Nov8

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

Sep21

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Aug20

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Feb28

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

ConcaUFO_RowsfromSheets

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

2020Nov11

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

jQuery Cookies

Small lib to allow jQuery to access cookies, nice small, needed it yesterday. ...

2019May12

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

Fancybox iframe

This is to demonstrate how to call a Fancybox from inside an iframe into parent ...

2019Jan15

DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

2018Dec25

FindFile_Word

Finds a file within open documents of current instance

2018Aug9

WorkbookClose_ANmar

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

2018Aug9

1 2