Hmm okay! This is essentially for a progress bar on a mail merge, so here's my dilemma. If recordNumber = 3 To 7 (potentially, if that's the merge range), how can I get a progress bar to read that? Stuck on this!


Me.ProgressBar1.Value = Round(100 / MergeCountTotal * recordNumber)


the above obviously is actually saying times 3, and the next would be times 4, until it reaches 7... but for the percentage to make sense, it needs to see 3 as actually being 1, of 4... damn this is confusing haha