Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

WorkbookSave_ANmar

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

Modal form open Workbook

Do not open workbook from userform after .show

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

Frm3.zip

IfFoundInList

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