Excel 2007 Macro - Range or .Range

[Event2020]

Hi

I am using Excel 2007.

When searching the web for answers / tips to writing macros when referencing a range (single cell or several) I have seen both

.Range("A1").Value = "

" and

Range("A1").Value = ""

used.

Can someone explain in simple terms what the difference is and when .Range or Range should be used?

Many thanks

 

[Fluff]

You only use the first example inside a with statement like

With Sheets("Sheet1")
   .Range("A1") = "Fluff"
   .Range("B1") = "MrExcel"
End With

 

[Event2020]

You only use the first example inside a with statement like

With Sheets("Sheet1")
   .Range("A1") = "Fluff"
   .Range("B1") = "MrExcel"
End With

Hi Fluff

Thank you for kindly replying - I love learning

So which method would you recommend for the below macro?

The macro is looking at a cell, B23, which has a number of option buttons linked to it and if the cell returns specific value, 3, 4 or 5 (ignoring 1 and 2) the macro changes the value of a different cell, B25, to 1.

The macro works fine but in the interest of doing it correctly I wonder if I was using the correct syntax?

Sub ResetNoCaseSelection()




    If Range("B23").Value = 3 Or Range("B23").Value = 4 Or Range("B23").Value = 5 Then
        Range("B25").Value = 1


    End If
    


End Sub

 

[Joe4]

When checking for multiple values, I would probably use a CASE statement.
See: https://www.techonthenet.com/excel/formulas/case.php