VBA – overflow error

Questions ArchiveCategory: ProgrammingVBA – overflow error
Chrysanthe Belgique asked 4 months ago

When I am debugging my code and stepping through each line, it works perfectly (everyhting outputs and calculates correctly) but when I run it all at once (in the Dev window or using a macro button) it says there is an overflow error. I have tried changing the variable type but it still won’t work.

1 Answers
James Gaskin answered 4 months ago

Overflow errors also happen when you try to jump to a cell that doesn’t exist (for example, offset one row when you’re already at the bottom of the sheet)

Your Answer

20 + 18 =