yap there are no data cause they get deleted on the menu initialization but that must be so every time its used there is a fresh set of variables. other data (that were used under the header) are of a personal character which is not to be shared....all the important data for this task are there trust me...;-)....if you click through as i explained above it will create few new entries on "krit" sheet and there raises the issue
also the columns("B:B") refers to the range where only strings are - tried out with typename function set on the variable and on the cell itself always returns string
btw. also tried to put "" to the match function (""" & choice(y) & """ ... ) didnt work either
regarding no data thats what i explain in the edit2....i thought of that problem so i skipped first set of variables to get to the point where there are data but still flawed results
Hope i´ve explained all thus far....;-)...now im off to try out the last thing you´ve proposed to declare MatB as variant which i didnt have (had it as long since the output should be numeric) but I´ll give it a shot lets see what´s the outcome....brb
EDIT: so I´ve tried to declare MatB as variant and the only result was that in debug print it gives nothing instead of 0 if i had no "set" before the actual code orerror message with match. highlightedobject required
Bookmarks