Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Background colour using VB
hi
just after workbooks.add insert this: Range("A2:M73:).interior.colorindex = 1 'black :) -----Original Message----- I wish to make make the background colour of all cells black prior to paste of an invoice details. I code upto now is as below but I need to add the background colur and then wish to close the workbook with code Range("A2:M73").Select Selection.Copy Workbooks.Add Range("A2").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False _ , Transpose:=False Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:=False _ , Transpose:=False Application.CutCopyMode = False Filesavename = Application.GetSaveAsFilename( _ fileFilter:="Excel Files (*.xls), *.xls") If Filesavename < False Then ActiveSheet.SaveAs Filename:=Filesavename, FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False End If End Sub . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text and background colour | Excel Discussion (Misc queries) | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Countif background colour is..... | Excel Worksheet Functions | |||
How to filter using background colour? | Excel Worksheet Functions | |||
Background colour using VB | Excel Programming |