digitalMoto.net

Ever tried to debug a loop inside a listObject.Range? Use get_Address(). It makes the process a lot easier.

Code: Read more…

Description:
Set a cell’s solid background color using a single user-defined color.

Code: Read more…

Description:
Set a cell’s background color to a vertical gradient using two user-defined colors.

Code: Read more…

Description:
WinForm controls placed in a worksheet while it is not at 100% will be positioned incorrectly. Here’s a simple workaround to change the zoom to 100% then revert to the previous setting.

Code: Read more…