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.