Using for next with two counters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

Im trying to use a for next statement with two counters.
What i have so far:

DDRowCount and DateCount1 are variables defined earlier.
say DDRowCount = 4 and DateCount1 = 5
DataRange is a variable too, of the rows of data.

For n = 1 To DRRowCount
For d = 1 To DateCount1 + 5
DataRange.Cells(n, d).Value = "test"
Next d
Next n

This doesn't seem to be working.
Can i please ask for some help on this.

Cheers.
Alby
 
Albert,

Always use Option Explicit as the top of your modules.
Doing that would quickly point out that...

DDRowCount is not the same as DRRowCount
It works for me after making the correction.

Regards,
Jim Cone San Francisco, CA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counter stops working 4
Scrabble Value calculation for Welsh words 0
Transpose & reorg data from 2 WS to new WB 2
Sum work hours to hours & nearest 10th of an hour 14
display a file in excel by using vba 0
Workbook locks up after Worksheet_Change operation 6
Looping : For... Next problem 1
Next without For Error 14

Back
Top