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