Search results 60

  2. Search results
  3. tables
Sorted from new to old.
Card image
End ( xlDown )

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

2023Aug28
Card image
ListPivotsInfo

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

2023Aug13
Card image
Refresh Table from View

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

2023Jul19
Card image
DB Functions (By AI)

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

2023Apr23
Card image
Arabic in MySQL

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

2023Apr12
Card image
ScrapeURL_ToSheet

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

2023Apr4
Card image
Range2Block

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

2023Mar6
Card image
ANmaRemoveDuplicates

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

2022Sep25
Card image
ANmAdvancedFilter

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

2022Sep15
Card image
LastRow_Remove

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

2022Aug16
Card image
ANmaSQL_UpdateDateStatement

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

2022Jul4
Card image
ANmaSQL_InsertStatement

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

2022Jul3
Card image
DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31
Card image
DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28
Card image
Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23
Card image
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29
1234