Search results 60

Sorted from new to old.
Card image
SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

Card image
LastRow_Remove

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

Card image
Export2CSV

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

Card image
DynamicFill

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

Card image
RowList_Matching

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

Card image
Row_PixelLocation

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

Card image
Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

Card image
NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

Card image
Most recent in Oracle DB

List the most recently added rows based on a date column.

Card image
Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

Card image
Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

Card image
CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

Card image
CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

Card image
Arabic VS Hindi numbers

Settings to force Microsoft Word to show Hindi numbers with Arabic text, or ...

Card image
FormatPhoneNumber

Formats a given 10 digit number into a nice looking phone number

Card image
pd

Format a number with total number of digits I used it to format a date as ...