View Full Version : For Each Next Loop problems
vinny2984
10-17-2008, 10:26 AM
can anyone tell me where thus code is wrong.
I'm trying to enter the formula into each of the cells in range admin.
thanks
Kenneth Hobs
10-17-2008, 10:36 AM
Oops, what code?
vinny2984
10-17-2008, 11:19 AM
good point,
For incr = 1 To 49 Step 4
For Each cell In admin
cell.Formula = "=SUMPRODUCT(N(INDIRECT(" '"&StationMembers&"'!cell.address")))"
cell.HorizontalAlignment = xlCenter
cell.VerticalAlignment = xlCenter
Next cell
Next incr
Bob Phillips
10-17-2008, 11:25 AM
For incr = 1 To 49 Step 4
For Each cell In admin
cell.Formula = "=SUMPRODUCT(N(INDIRECT('StationMembers'!" & cell.Address & ")))"
cell.HorizontalAlignment = xlCenter
cell.VerticalAlignment = xlCenter
Next cell
Next incr
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.