LinkBack URL
About LinkBacks
I keep getting the error "Duplicate Decleration In Current Scope" can anyone help me out?
Please Login or Register to view this content.
I keep getting the error "Duplicate Decleration In Current Scope" can anyone help me out?
Please Login or Register to view this content.
Ok I did a little tweaking and got passed the original error...BUT now I am getting a new error which says "Block If without End If"
Please Login or Register to view this content.
Well, you do declare the variable twice.
new_obs is first declared as a variant (by omitting the data type), then you declare new_obs as an integer. You do the same with the new_data variable.
Delete the declarations with no data type setting.
Then you will find that the code bombs on the line
What do you actually want to do?Please Login or Register to view this content.
cheers
Last edited by shg; 06-27-2010 at 07:29 PM.
Creating a application that enters data into a quality control chart.
you only close one IF statement here
Please Login or Register to view this content.
ok NOW I get an error which states "expected function or variable" and highlights Range at the top
in this line?
If so, it does not surprise me. What do you want to do in this line of code?Please Login or Register to view this content.
At this point I'm so tired and fed up with this I don't even know haha do you see anything that stands out in that code that could be incorrect
Sorry, but you'll need to tell me what you want to do.
As I see it, you are assigning the variable new_obs the result of a comparison between a cell and a selected sheet. This makes no sense whatsoever. Maybe you want
But I can't read your mind.Please Login or Register to view this content.
"set the value of the new_obs variable equal to the value of cell a3 in the qc data worksheet plus 1. (hint use an object reference that includes the object hierarchy from the sheets collection to the range object.)"
the value in a3 is 20
Hmmm ........
........do you see anything that stands out in that code that could be incorrect
Basically everything ......
I tried breaking down your code, but it is not possible to see your intent.
You would do best to post a sample workbook showing what you need done
It should clearly illustrate your problem and not contain any sensitive data.
Cheers
The last quote sounds like a homework assignment.
Marcol, we're out of here.
.................
Last edited by Bono1083; 06-27-2010 at 08:26 PM.
Is asking help on a homework assignment wrong?
Look, it looks as if you have a homework assignment, manually wrote some code and now you're using us as the debuggers. It does not work that way. We won't do your homework for you, since you need to do that yourself.
You are welcome to ask specific questions to specific problems, but you will need to show that you would know how to apply the answer.
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks