Search results 14

Sorted from new to old.

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

2024Jan15

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

2023Aug28

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

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

2022Aug16

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

2022Mar11

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

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

2020Feb7

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

2020Jan3

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15