Hello all expert,
I have a program in module 2 in attached excel file that help me find some rows in sheet1 and put in sheet2. I'm keep running into run time error eventhough I find nothing wrong with the code. Any input will be greatly appreciated.
Thanks,
VB
Hi your code stop on this line
when TopLastCol and SubLastCol have value =1 so when You minus 1 or 2 according the code error will appear because there is no cells(7,-1) or cells(7,-2)If Cells(TopRowCtr, TopLastCol - 1) = Cells(SubRowCtr, SubLastCol - 2) And _
Cells(TopRowCtr, TopLastCol - 2) = Cells(SubRowCtr, SubLastCol - 1) Then
Could you explain what is criteria of searching and copying
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
It is not that difficult to debug.
On the line
You are setting up the condition so that when "Cells(row,column)" gets evaluated, the column value is either zero(0) or negative. The lowest value allowed is 1.
Please Login or Register to view this content.
I recommend learning some basic debugging skills.
Last edited by Dennis7849; 03-20-2012 at 05:09 PM.
Thank you all, I was just trying to compare the first number and the last two numbers. If the first numbers are the same and the last two numbers are reversed then put them in sheet2. I've already gotten it figured out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks