Search results 29

Sorted from new to old.

ANmAddress_Dimensions

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

2024Nov8

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

Can't find Project or Library

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

2023Sep1

Frm3

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

2023Jul30

List_of_Names + DeleteNames

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

2023Jul9

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

2021May31

Bing Desktop wallpapers

Folder where

2021Mar5

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30

ANmaRedirect_Plus1

Function to log the redirects that happen into website It is merely used with ...

2019Oct25

1 2