Multiple format in single line

[aaryan bl]

Hi Guys,

How to write code for multiple formats for one range in 'single line'. (Like - Range("A1").NumberFormat = "@" & Range("A1").Font.Color = vbRed)
The above example is working in two line, but not working in single line. I want to do it in one line because the range is same(A1).

This is for example and it's working for paste function;
(Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks :=False)

Thanks,
Aaryan BL

 

[MARK858]

Do indent spaces count?

Only if you Indent your code ?