Jumat, 03 April 2015

[ExcelVBA] Re: Simple loop help


Thanks all for your help. I found an alternate solution last night that worked. This morning I tried copy/paste my original formula and, surprise, it worked correctly with no errors, so I could not replicate the problem.

Lessons learned:

  1. Include errors in request for help so others can see what I see.
  2. No colon after "Else" statement. (FWIW VBA automatically placed colon).
  3. Do not code at 2 a.m. Brain no longer awake.

One other question, is "Dim CurrentCell As Long" correct? Or should it be "Dim CurrentCell As Range"?


Posted by: jeff.flanagan@duffcorp.ca
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar