Originally Posted by
Ventoux
@6string My bad, i declared my variable's value as Range("F7") and thought i could just write .ClearContents in a later statement behind the variable's name, instead of writing Range("F7") again. This didn't work, i had to specifically write Range.
Let's clear up terms....you declare a variable's type and set its value. If you write code like this:
as soon as you type that "." you will get a list of class members for Range. You can also write
which is what I think you just said didn't work. If it didn't work you've got some other problem.
@debraj
IF is neither Class nor Enum.. okay
"If" is a statement, not a class or enumerated value. So VBA will not give you any sort of prompt for what can go after it.
Bookmarks