Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I keep getting that error when I use this code
Sub test() Dim a As Integer For a = 50000 To 50100 Range("J1, K28").Value = a ActiveSheet.PrintOut Next a End Sub but it has always worked perfectly when I used this Sub test() Dim a As Integer For a = 20000 To 20100 Range("J1, K28").Value = a ActiveSheet.PrintOut Next a End Sub But I can't figure out which part is causing the problem |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Overflow error.. why? | Excel Discussion (Misc queries) | |||
runtime error '6' overflow | Setting up and Configuration of Excel | |||
Overflow Error | Excel Discussion (Misc queries) | |||
overflow error | Excel Programming | |||
Run-time error 6 Overflow | Excel Programming |