Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-31-2018, 11:11 PM
phoenixmoto phoenixmoto is offline vba for next loop Windows 7 64bit vba for next loop Office 2007
Banned
vba for next loop
 
Join Date: Jul 2018
Posts: 11
phoenixmoto is on a distinguished road
Question vba for next loop

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.
Reply With Quote
 

Tags
for next loop, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
vba for next loop Do Loop bug donlincolnmsof Word VBA 11 09-07-2017 10:07 PM
vba for next loop Macro Loop Help Twizzle008 Word VBA 15 09-18-2015 03:20 PM
vba for next loop Loop - Row increment jrt Excel Programming 1 04-16-2015 01:46 PM
vba for next loop End or alter a loop? DJSOUND Word VBA 1 10-11-2013 08:11 PM
vba for next loop How to a For loop in VBA Jennifer Murphy Word VBA 1 01-29-2013 03:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft