Excel VBA - Cell Referencing Watch More Videos at: www.tutorialspoint.com/videot... Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
I find it really amazing that Indians are good in explaining things clearly. Easy to understand. Straight forward. Awesome. Big hands from Philippines.
Thank you so much for your elaborate and simple explaination for understanding the intricacies of cell reference and making beginning in vba. I am a senior citizen involved in environmental consultancy and was looking desperately for simple yet fast tools in processing vast range of data. God bless you.
Excellent, I really appreciate your effort, Thanks A Ton Again :-) This is proper way of teaching, step by step mentioning minor things along the way and all in a short 5-6 min video Awesome presentation FIRST TIME I GET WORD BEST TUTORIAL . Very Unique way of teaching, You are Great Trainer Keep it up.
I have been trying to understand VBA for a long time. But always failed because of the videos got to complex for me... But this series is very good. I am leaning new things now every day
Is there a way to set one of the reference values in the cells function to a variable? In python if you have an array, you can do something like this. array1 = [1,2,3,4,5] b = 0 while(b < len(array1)): print(array1[b]) b = b + 1 Is it possible to do something similar with the cells function? So something like MsgBox(cells(1&b))....I keep trying it and it is not working for me...
Hi, can u please let me know why you used Range (a1) for a single cell, couldn't we use cells (1,1)? Range shouldn't be used for taking more than 1 cell?
Range can be used for more alloting values to more than 1 cell : eg : Range("A1:A12).value="Jakarta". If you want to allot the value "Jakarta" using cells() function , you have to use a macro. Usually cell() function is used to allot value to a single cell. For allocation to multiple cells use a macro
I think when we use Range() there are various methods associated with "Range" like range.copy, range.delete, range.borders, etc. So it can be more flexibly used. Thats what i think please check out.
Thanks a lot for your nice presentation. here i have a question. in some cases you used .vaue but not for all. could you please explain the use of "value".
Hi For a particular cell use .value and for a range like a1-a10 in this case no need to use .value 07:54 u can see the difference for range c1-c10 and a2-a10 .value is not reqrd
I do not know if this comment will get across to the lecturer. I was thinking if you have any website or a link where we can practice exercises to VBA coding. Thank you.
Fantastic, Sir is it possible to merge the dynamic ranges, as the Syntax is Range("A3:C6") I want to make this 3 and 6 dynamic and to be replaced with i which is dynamic in nature or in other words how to merge every nth An to Cn ranges.....
What if we want numbers in equal intervals in the range C1:C10? E.g. here we gave "tutorials" for all, but if we want 2, 4, 6 and so on...how would we get that?
Awesome teaching method. The only issue I faced so far is "if I press F8" on keyboard, step into is not working. I need to use mouse pointer to click the same in the debug menue. Can anyone help?