Excel 2010 VBA Tutorial 2 - Referencing Ranges

How to reference ranges within your worksheets.

[gokubadgoku]

You're a life saver... i'm working on an internship this summer and all i have to do is macros in excel! thanks!

[pauloweberbianchi]

I have no words to express my gratitude. My most sincere thanks

[YourprogrammingnetworkCoUk]

You need to put .value on the end of the second range reference aswell as the first as you are taking the value of the range and assigning it to the value of the other range. Hope that helps!

[carolinealves]

i loved but don't have legends in Portuguese, but I loved! congratulations

[sidkings]

Hi Matty.. I cant thank you enough. These videos are immensely useful. I should have done gotten into VBA years ago.. but better late than never ey? :-) Cheers..

[colina]

Nice and straight forward way to explain referencing.  Hands on too.  :)

[shaileshmishra]

i didn't understand whatever you said after 6:50. still a Great tutorial

[shanguillard]

hey man i love you for this job danke thinks a lot

[wadieseruge]

matty, thank you for posting this video. how do you connect cells or codes together to make it do something? i mean a log in screen, and so on.

[alebo]

Hello Matty, I tried to write the VBA code on Excel 2013 but it is not working, would you be able to help? Thank you very much.

[amiralitejani]

Is there any way to get the macro values in all sheets or specified sheet? In the video, we are practicing in Sheet1 but if i want to get those values in Sheet1 and Sheet2, is there any way to do it?? I tried (Sheet1:Sheet2) to no avail :)

[anushkagirdhar]

@yourprogrammingnetwork
it shows"can't execute in break mode"or"subscript out of range"
please help!

[lajoskato]

run time error '9'
subcription range :(

[christinazambos-graves]

How can I change the color of my font? Selection.font.color=RGB(255, 255, 255) is what I've been putting in and changing the numbers but it's all white.

[deepsekhar]

Hi sir
here it is showing an error "can't execute in break mode".Can u please tell me the solution?

[ziaulhaq]

Their is and error "Object doesn't support this property or method "

please help

[bigfattybola]

sidkings yeah you should I am only 10 and I am doing this

[jyosthnadevi]

tried many times to run the macro .. but it's showing error message"cannot run in break mode"

[elsiddigelhafyan]

If i typed in anything in a4 would it show up on a5?

[김현진-vye]

Can you change the tone of your voice please!