Thread
:
Runtime error 13-- Setting a variant Range?!
View Single Post
#
2
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 13
Runtime error 13-- Setting a variant Range?!
ANSWERED MY OWN QUESTION:
Dim MyRange as Variant
MyRange = ("C" &(Me.txtItem_Number.Value) & ":G"
&((Me.txtItem_Number.Value)+ 2))
Range(MyRange).Clear Contents
That Set thing always gets me! erg!
:)
wrote:
Why doesn't this work?
Dim MyRange as Variant
Set MyRange = ("C" &(Me.txtItem_Number.Value) & ":G"
&((Me.txtItem_Number.Value)+ 2))
Range(MyRange).ClearContents
I also tried Dim MyRange as Range. How can I work around this when I
need to clear a different area every time the macro runs?
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]