Search results 60

Sorted from new to old.

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

Sep30

ShapeDelete

Safely remove certain shape from worksheet

Sep30

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

May16

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Mar10

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Feb19

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to file or delete ...

2024Oct29

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

2024Aug7

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

1 2 3 4