Solved: Sync Loading Bar with actual Process

[defcon_3]

I attached the file. It does sync but the progress bar dont reach the end of the bar. Isnt it should be dependent on the data that is being processed.? The file with the progress bar is "zwei.xls" it fetch the data from "eins.xls" using CopyCat macro.

Thanks.

[defcon_3]

Solved.
frm.KoolPrgBar.Value = i / Last_Rw * 100