![]() |
#1
|
|||
|
|||
![]()
Dim num as integer
sub mac1() For num = 1 to 50 A = num * 2 cells (1,1) = A next num end sub If i run this code cell cell(1,1) displays 100 i.e 50 * 2 instead of lowest num no i.e 1 * 2 which is equal to 2. Even if i declare A as integer problem persists please help. |
Tags |
for next loop, vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
donlincolnmsof | Word VBA | 11 | 09-07-2017 10:07 PM |
![]() |
Twizzle008 | Word VBA | 15 | 09-18-2015 03:20 PM |
![]() |
jrt | Excel Programming | 1 | 04-16-2015 01:46 PM |
![]() |
DJSOUND | Word VBA | 1 | 10-11-2013 08:11 PM |
![]() |
Jennifer Murphy | Word VBA | 1 | 01-29-2013 03:30 AM |