arial

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 ActiveSheet.Range("A4:D4").Select With...

Hi, 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? For example: 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: Sheets("Sheet1").Select Range("C" & CStr(LSearchRow)).Select Selection.Copy Sheets("Sheet2").Select...