I like to have all my spreadsheets as Arial size 8, many spreadsheets I receive from colleagues and clients as different sizes and font and I just change manually by highlight all and edit.
Should I just use a macro and shortcut key to change this or can anyone suggest a better way?
I am looking to add a textbox with the word REVISED in Red and then for it to print on the report. I cant seem to get it to print in color. Current code I below.
' Format certain data ie file header name and sum of data
Is there any way that I can download a listing of all the fonts that I have and in each cell they change to that font?
CELL A1 - would say Arial - in the that font
CELL A2 - would say Arial Narrow - in that font
The situation is that I copy certain data based on criteria using macro in the same workbook from one sheet to another, like this:
Range("C" & CStr(LSearchRow)).Select