Search results 78

  2. Search results
  3. Range
Sorted from new to old.
Card image
RangeValues

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

2024Jan25
Card image
UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28
Card image
AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1
Card image
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7
Card image
End ( xlDown )

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

2023Aug28
Card image
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10
Card image
List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9
Card image
SubZero

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

2023May23
Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11
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
Range2Block

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

2023Mar6
Card image
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18
Card image
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11
Card image
ANmAdvancedFilter

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

2022Sep15
Card image
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1
Card image
AddDatabar_ConditionalFormatting

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

2022Aug22
12345