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

  2. Languages
  3. VBA-Excel
Card image cap
ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24
Card image cap
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13
Card image cap
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7
Card image cap
Can't find Project or Library

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

2023Sep1
Card image cap
End ( xlDown )

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

2023Aug28
Card image cap
NumberFoundinsideTag

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

2023Aug21
Card image cap
SheetTabColor

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

2023Aug17
Card image cap
ListPivotsInfo

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

2023Aug13
Card image cap
CopyDynamicRangeValue

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

2023Aug10
Card image cap
WorkbookSave_ANmar

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

2023Aug9
Card image cap
Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3
Card image cap
ANmaHTMLImgDownload

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

2023Aug2