foxyginger
08-02-2017, 10:46 AM
Okay, this is just a shot in the dark. BUT, I've opened someone else's MACRO-integrated excel file and we are trying to convert a flat file (using notepad) to a different format utilizing this MACRO.
It is only working for some flat files, and not others but when we look through they are all in the same formatting and everything (no extra spaces, etc). The error that comes up when running some of the forms is:
"Run-time error '1004': Select method of Worksheet class failed"
:banghead:
and when I click "debug" -- it seems the issue is this one line of code:
ActiveSheet.Previous.Select
I've never troubleshooted someone else's VBA and I'm brand new to VBA anyway.
Can anyone explain what they may think is happening, or at least give me the next actionable steps of how to problem solve this error? I know this is vague, sorry about that.
It is only working for some flat files, and not others but when we look through they are all in the same formatting and everything (no extra spaces, etc). The error that comes up when running some of the forms is:
"Run-time error '1004': Select method of Worksheet class failed"
:banghead:
and when I click "debug" -- it seems the issue is this one line of code:
ActiveSheet.Previous.Select
I've never troubleshooted someone else's VBA and I'm brand new to VBA anyway.
Can anyone explain what they may think is happening, or at least give me the next actionable steps of how to problem solve this error? I know this is vague, sorry about that.