Forum Discussion

keelinga's avatar
keelinga
Copper Contributor
Dec 02, 2021

VBA: Dim i As Integer

How do I find out what "i" means, or what "j" means when I say "Dim i As Integer?"

 

Then I also see:
Dim c As Integer 

 

What???

Macros and VBA

1 Reply

  • keelinga's avatar
    keelinga
    Copper Contributor
    Dec 02, 2021
    I figured it out. It's a label I'm declaring for the .Cell reference.
    So when I want to reference a row I'm using the "i" label
    And when I want to reference a column, I'm using the "j" label
    I'm also using a worksheet reference using the "c" label.

    For example
    Cell (i,j)
    Worksheet(c)

Resources