There is no “FIND” function in Excel VBA, yet there is a replace. I want to search a string to find the occurrence of a sub-string.

I need to use the following

If InStr(x, y) = 0 Then… [meaning False, y isn't found within x]
If Instr(x, y) <> 0 Then… [meaning True, y is found within x]

Here is a keyboard short cut to select all the cells in a region bound by blank columns and rows. This is very useful if you need to select an area to sort or create filters or pivot tables.
For example, if you sort data, Excel first selects a region that it will sort. But if you need create a pivot table you need to tell Excel where to start.
If you want to see what Excel considers to be the region surrounding a cell, simply select the cell and press Shift+Ctrl+* (asterisk). The region is highlighted.
By definition, a region is the area surrounding an active cell that is bounded by blank columns and rows. Sometimes people refer to a region as a table or a list.