Microsoft Office Forums - View Single Post - [Solved] Fifteen Days From Today's Date, (Not Counting Saturday & Sunday).

gmaxey · 07-26-2017, 11:22 AM

SR,

Yes range is a method of Selection among other things but when declared as a variable, it is an object. Step through this code and watch your locals window.

Code:

Sub ScratchMacro()
'A basic Word macro coded by Greg Maxey, http://gregmaxey.com/word_tips.html, 7/26/2017
Dim oRng As Object
Dim oRng1 As Range
Dim oRng2
  Set oRng = Selection.Range
  Set oRng = Selection.Range
  Set oRng2 = Selection.Range
lbl_Exit:
  Exit Sub
End Sub