Help with Macro! Overflow Error

Hi All,

I've been browsing through a lot of these Overflow error threads and after countless hours of reading and trial and error, I can't seem to get my macro to work.

I should probably say that this is for one of my studies looking at heart rate variability (inter-beat interval [IBI], measure in milliseconds) data during sleep following a stress task.

I'm trying to do the following:
1. Map IBI data (in ms) to actual time of study phases.
2. Break the phases into segments (on sheet 2)
3. Export these IBI segments into .txt files so that each .txt file contains only those IBIs that match the time segments

I've adapted a Macro from a previous study, and it works.... up until Sleep3 phase of the study...

Not sure why it's working for half of my data but not for the other half. I get a "Overload" error. I changed the variable type to "Long" so it should be working...

I've attached the excel file with the Macro in it.

Any suggestions guys? I'd really appreciate it.

Thanks!!!

Abdiel

you defined a variable, to hold row position, as Integer, which only goes to 32,767
it needs to be defined as Long

Please Login or Register  to view this content.

Welcome to the Forum Abdiel!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.