Search results 102

Sorted from new to old.

ANmaFilter3

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

2023Oct13

USB format in Android

What is the best format to use a USB storage for using in Android phones and ...

2023Sep28

End ( xlDown )

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

2023Aug28

ListPivotsInfo

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

2023Aug13

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

1 2 3 ...6 7