Forum Discussion
runtime error 6 overflow help
I was reading up on why I was getting this error and I have no clue how to fix it. I have "Dim row As Integer" and then later in that sub I have "row=row+1" (as shown in the picture.)
I'm not really sure why this is happening now because this error had never shown up before.
2 Replies
You can change this:
Dim row As Integer
to this:
Dim row As Long
Datatype Long is for values in the range from -2.147.483.648 to 2.147.483.647.
- I'm pretty sure it worked but there's another error in that sub so once it works I'll let you know!
