Forum Discussion

LilYawney's avatar
LilYawney
Brass Contributor
Apr 02, 2023

VBA clarification

I have yet another question regarding a macro on the spreadsheet that I translated from French to English. I was wondering if someone could tell me what "nb" means in this code; I've also provided the original French code in case that helps!

 

2 Replies

  • LilYawney 

    nb_ligne_a_inserer is the name of a variable. It is not strictly necessary to translate it.

    Nb is short for nombre = number, so you can keep it, but you have to be consistent.

    The highlighted name is nb_row_a_inserer, but in the next line you use nb_row_to_insert. Use the latter.

    • LilYawney's avatar
      LilYawney
      Brass Contributor
      Thank you! I'm VERY new to VBA coding if you couldn't tell

Resources