I have this code which reads in an input file...........today i recieved a new input file. I get a runtime error in the following procedure and i am not sure why. The actual debugger highlights the following line of code.
Please Login or Register to view this content.
the procedure which contains the error is shown below.
Please Login or Register to view this content.
Maybe take out the second .Resize command, seems redundant.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
but it has run like this using both resize commands for some time.........i wish i could post this "new" input file but i cant...........
When you DEBUG at the moment of error, and it highlights that line of code, what are the current values of all the variables in that code? Hover your mouse over them or use the Watch Window to get those.
the only variable that shows any value is
last_row_in_study_col
and its value is showing as 4384
Maybe:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks