LinkBack URL
About LinkBacks
Why does this give me a debug error?
I get a debug error saying
Please Login or Register to view this content.
"Compile error: Invalid use of Property"
and it highlights "Range" in the second line of Range("G16") +1
Why does this give me a debug error?
I get a debug error sayingPlease Login or Register to view this content.
"Compile error: Invalid use of Property"
and it highlights "Range" in the second line of Range("G16") +1
Last edited by garretonufer; 09-23-2009 at 05:19 PM.
What is it supposed to do?
Entia non sunt multiplicanda sine necessitate
If the value of B5 = 1 then increase the value in cell G16 by 1
Please Login or Register to view this content.
need to use Range("G16") = Range("G16") + 1 to increment the value in the cell. Excel is putting the space there because there is no equals sign... Range ("G16") instead of Range("G16").
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks