Search results 60

Sorted from new to old.

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Feb3

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Jan24

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

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

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

LastRow_Remove

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

2022Aug16

ANmaSQL_InsertStatement

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

2022Jul3

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

SumOf_3Filters

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

2021Jan29

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

1 2 3 4