Export Excel Range to Image (jpg/png/gif) using Vba? This code ill convert the data in Excel workbook into a jpg image file as how it is displayed on screen. The image format can be jpg, png or gif. We have not tested if this supports other image formats as well, […]
How to do Spell Check in Excel?
October 31, 2020
How to spell check in Excel? Easy steps to invoke checkspelling module in Excel cell, range, worksheet or word thru menu and VBA Macro,
Highlight Duplicate Values in Excel with Color
October 31, 2020
Learn how to highlight duplicate values in Excel using the conditional formatting. Also the formula to find duplicate entries in a Excel range.
How to make every other Row or Column shaded in Excel?
Learn how to make every other row shaded in excel. Alternate Rows/Columns background color can be set using conditional formatting, VBA & by inserting table
How To Sort by Color in Excel?
Learn how to sort by color in Excel using menu & VBA code. You could sort either by cell background color or the font color. Get this free code sortbycolor.
How to Disable Images in Firefox, Chrome, IE?
How to Disable images in Firefox, chrome, IE browsers. Also get Excel vba macro code to disable images in IE. Reopen closed tabs, Restore last active sessions in Firefox, Chrome, IE .,
Excel Count Cells By Color – Using VBA ColorIndex – CountByColor
Get Excel VBA to count cells by color. Input range. Use this to also perform color by sum, sumbycolor or countbycolor tasks. Its all about sum by color.
Excel VBA Color Index List – Worksheet Interior Font – Colour Codes
Excel VBA Color Index List contains 56 colors that is used in the Color palette to change the background color, border or font color. Code for VBA Color.
Excel Vba RGB to Hex,Long – Hex to Rgb,Long – Color Code Conversions
October 31, 2020
Conversion of Excel VBA color codes from Long to RGB, Hex and vise versa. VBA color codes can be used on Excel background,interior or font color codes.
Excel VBA – Get RGB Color of Cell – Change Background
Use this VBA Change Cell Color Excel macro, read Excel cell color & convert color index to RGB code. Learn how to change cell background color using VBA..
