Save Prompt Without Any Changes
Sometimes when you open an Excel file and then close it without making any changes on it. But to your surprise, Excel pops a dialog...
Tagged: vba
Insert Hyperlinks from Text (VBA)
When you need to insert a series of hyperlinks into an excel sheet from a list of links, this small macro named “insert hyperlinks from...
First Empty Cell In A Column (Excel VBA)
Locating first empty cell in a column is a common issue for alot of macros that are designed selecting cells or pasting values to orher...
For Each Loop (Excel VBA)
For Each loop is for looping through each element in a collection. It is especially useful when you don’t know how many elements there is...
Select Case (Excel VBA)
Select Case Statement lets you execute several group of statements based on value of an expression. It works like CHOOSE Function in Excel.
For Next Loop (Excel VBA )
For Next loop repeats a statement for a specified number of times. This is your basic loop for alot of situations. You will use it...
