Browse codes

Search results 35

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

Aug28

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

Aug13

Forces Excel to not convert numbers during moving them across sheets, or ...

May23

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

Apr23

3 functions to download posts, adds new post and to upload and set featured ...

Apr22

Scans folder and its all subfolders (2 levels only) for files then put file ...

Apr7

Imports multiple CSVs found in a folder into worksheets of active workbook ...

Mar20

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

Mar6

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

2022Sep15

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

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

2022Aug16

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

2022Jul4