Can someone please help....and tell me what does "ar" mean in this line of code
![]()
Please Login or Register to view this content.
Can someone please help....and tell me what does "ar" mean in this line of code
![]()
Please Login or Register to view this content.
Last edited by Darel; 09-30-2011 at 11:52 AM.
It depends what the variable are. probably AR is aCell(Range) & it's looping through each cell in Row whatever lRow is
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Basically it's a Range variable representing each individual cell.
If lrow equals 3 then that would translate to
"for each cell in A3:A5", and ar would hold a reference to each individual cell in turn - A3, A4 and A5.
Thanks guys....very helpful
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks