Best VBA Learning?

montecarlo2012

Well-known Member
Joined
Jan 26, 2011
Messages
536
Office Version
2010
Platform
Windows
Michael M. I really appreciate your info, you make my day. and yes, you are right about that. I am trying to build a kind of physical steps that let me see the loop, and sometime I found interesting videos in Hindi, even if I don't have any clue what they say, but watching the spreadsheet they have really good understanding the LOGIC behind the code.
example
For x = 1 to 5
Cells (x, x).value = x
next
the results here are a diagonal, the question is: how they figure it out to get here,
1587863985119.png

because you write first in a paper what you want and start to write in cell notation or A1 notation: watch. A1, B2, C3, D4. this line is the same if you write like 1,1 - 2,2 - 3,3 etc meaning the Index for the Row and Column are Equal so you are now enable to write , (row, col) and because they are equal then x = x or in other words you can plug Cells (x, x) that is part of what I am looking for other kind of codes I know how they work, but, there are a but, HOW they work is different than WHY and How you arrived to that conclusion. Because around internet and books I have they always just say
something for me so silly
for i = 1 to 5
►do something◄
next, aha, give me a break, how from here you will be able to develop a real loop hahahahaha, ridiculous, all those web pages and youtube are full of this little ..... you know......
would be really nice if you accept a conversation in the section call ("start a conversation") ok my friend, thanks and I hope to hear more.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,102,546
Messages
5,487,493
Members
407,604
Latest member
jortronm

This Week's Hot Topics

Top