Explain With statement notation?

[Desu Nota from Columbus]

Can someone explain the notation for With statements?

Why is there a period? Do you use a "dot" before every line in the with statement? If not, why/when do you use/dont use the period?


I understand With statements function, but I don't understand the syntax.


Thanks.

 

[Sektor]

[COLOR="Blue"]Sub[/COLOR] WithWith()

    [COLOR="Blue"]With[/COLOR] Range("A1")
        .Value = 1
        [COLOR="Blue"]With[/COLOR] .Font
            .Name = "Arial"
            .ColorIndex = 6
        [COLOR="Blue"]End[/COLOR] [COLOR="Blue"]With[/COLOR]
        .CurrentRegion.Copy
        .PasteSpecial xlPasteValues
    [COLOR="Blue"]End[/COLOR] [COLOR="Blue"]With[/COLOR]

[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]


[COLOR="Blue"]Sub[/COLOR] WithoutWith()

    Range("A1").Value = 1
    Range("A1").Font.Name = "Arial"
    Range("A1").Font.ColorIndex = 6
    Range("A1").CurrentRegion.Copy
    Range("A1").PasteSpecial xlPasteValues

[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[Jonmo1]

The dot means you are referring to whatever was referenced in the With.
You don't have to use the dot on every line, just the parts you want to refer to the reference in the With..

With Sheets("Sheet1")

With the With statement above, in subsequent code, instead of writing
Sheets("Sheet1").Range("A1").Value = "Hello"
You just write
.Range("A1").Value = "Hello"

Hope that helps clear it up.

 

[Ruddles]

Or to put it yet another way, this:-

With [COLOR=red][B]wks[/B][/COLOR]
  [B][SIZE=3][COLOR=red].[/COLOR][/SIZE][/B]Range("A1").Copy Destination:=[SIZE=3][COLOR=red][B].[/B][/COLOR][/SIZE]Range("X99")
End With

is equivalent to:-

[B][COLOR=red]wks[/COLOR][COLOR=red].[/COLOR][/B]Range("A1").Copy Destination:=[COLOR=red][B]wks.[/B][/COLOR]Range("X99")

I'm not sure if this helps: http://msdn.microsoft.com/en-us/library/wc500chb(v=vs.80).aspx.

 

[Desu Nota from Columbus]

Thanks for the explanations everyone.