Search results 191

  2. Search results
  3. add
Sorted from new to old.
Card image
RangeTakePicture_Linked

Converts a range in Exce lsheet into picture. linked or unlinked. Important ! ...

Sep30
Card image
ShapeCreate_SomeVariables

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

Sep30
Card image
Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Jun30
Card image
Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

May27
Card image
UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

May12
Card image
1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

May12
Card image
Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

May11
Card image
MathInsideText

Return string after applying math to each number found inside the string. ...

May8
Card image
ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

Apr19
Card image
FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18
Card image
String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Apr10
Card image
String_S

Generate repeated text, like String() the function but with ability to repeat ...

Apr10
Card image
DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Apr6
Card image
DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12
Card image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2
Card image
ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12
12...1112