VBA Loop counter

You can display it in the status bar, but not quite next to the Zoom.

Why are you looping through over a million rows instead of just the rows being used? This will waste a huge amount of time processing rows with no data. I was going to fix that but I don't know what your real data looks like.

Variable "row" is declared as Long but it must be an Object or Variant so I declared it as Range. I do not know how you got this code to compile.

I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors.

Please Login or Register  to view this content.