I have changed my code to exclude an anomaly I have in my code, I have added this line and although I know data meets this condition it is not finding any true conditions. I can't see anything wrong with it though, is there something I am missing??????
Please Login or Register to view this content.
What does row1 and row represent? Can you provide more of the code?
I am remotely logged into the office computer and it will not allow me to copy paste outside sisco.
row1 and row are two sets of values I am trying to match, a list and raw data (i.e. row1=1 & row=1) then it matches the following condition and this is the part I have changed and it has stopped working since I have changed it
Please Login or Register to view this content.
Last edited by Sc0tt1e; 04-21-2015 at 11:32 AM.
Hard to say without the data, but it there are two likely causes. One is that you haven't specified which worksheet you are referring to and the code may not be using the one you think (it will default to either the active sheet, or the sheet containing the code if it's in a worksheet code module); the other is that the values actually don't match your criteria - remember that your text criteria are case sensitive.
Everyone who confuses correlation and causation ends up dead.
Example of the data attached, and I've copied and pasted the text values from Excel to the VBA code
You didn't address my first point, which is probably the most likely. When you open the template workbook, it becomes active, so this line refers to its active sheet:
Please Login or Register to view this content.
How many times do I have to get caught out by the same bloody mistake, Romper you've saved my Hiney again mate
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks