VBA-Excel 243 Visual basic for applications that works only in Microsoft Excel, aka macros

Card image cap
Any2Dec

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

Card image cap
Can't find Project or Library

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

Card image cap
End ( xlDown )

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

Card image cap
NumberFoundinsideTag

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

Card image cap
SheetTabColor

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

Card image cap
ListPivotsInfo

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

Card image cap
CopyDynamicRangeValue

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

Card image cap
WorkbookSave_ANmar

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

Card image cap
Modal form open Workbook

Do not open workbook from userform after .show

Card image cap
ANmaHTMLImgDownload

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

Card image cap
Frm3

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

Frm3.zip

Card image cap
IfFoundInList

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