shail has attended:
Excel VBA Intermediate course
I have recently come across that the program would not accept th
I have recently come across that the program would not accept the variable and it would not let me move cursor(yellow) down the lines when pressed F8. however the same programme could be run from another spreadsheet. do you think i have accidently switched off some function?
RE: I have recently come across that the program would not accep
Hello Shail,
Thank you for your question. I assume that you have enabled Option Explicit and that you have declared the variables correctly. When you say that the code runs fine in another spreadsheet, does the other spreadsheet contain similar data?
In the spreadsheet where F8 doesn't work, does it not work at all or does it run down to a certain line and then stop?
Does your F8 key usually step through code without problems?
Kind regards
Marius Barnard
Excel Trainer
