Search results 90

  2. Search results
  3. cell
Card image cap
Column1Range

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

2023Oct7
Card image cap
End ( xlDown )

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

2023Aug28
Card image cap
ListPivotsInfo

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

2023Aug13
Card image cap
CopyDynamicRangeValue

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

2023Aug10
Card image cap
List_of_Names + DeleteNames

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

2023Jul9
Card image cap
SubZero

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

2023May23
Card image cap
Range22DimArray

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

2023May11
Card image cap
ScanFolder

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

2023Apr7
Card image cap
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14
Card image cap
Range2Block

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

2023Mar6
Card image cap
Range_Add_or_Subtract

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

2023Feb18
Card image cap
Cell_Add_or_Subtract

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

2022Sep1