Hi, thanks for your videos. I ask you for help on the vba interface. The right edge of the page where the code is written, where the icons appear: bookmark (in blue), breackpoint (red) and pause debug (in yellow). This border has disappeared and I can't restore it. Can you help me?
Sir, At 5.35, in your video, how the yellow arrow is appearing to manually run the code, what are the keys to activate ? I am not clear at this juncture.
Not the RGB value, although that is possible as an alternative way to set the colour. This is the color index. I found out what the number was before the video by assigning the colour to a cell, and then in VBA testing what the colour of that cell was.
Hi dear sir I hv query in excel....I want a value which is located in my sheet1 when I put formula I could get its cell address ....like a finder works.. I m trying it from this formula =CELL("address",INDEX($A$18:$A$24,MATCH(A26,$A$18:$A$24,0))) but in this formula hv limitations of criteria...if I increase it’s criteria than it’s not working ......help me ....sir I want data is located anywhere in the workbook when I put the formula I could get the results that’s value addresses....help me
Computergaga sir but in vlookup the value columns range will be defined than we can get the results....but in my case columns ranged will be not defined..... I hv lots of name in my sheet1 in different columns &I can change it’s columns as per my desired columns....I think it will be only on vba.....
Super-useful. Thank you!
Glad it was helpful!
Hi Alan.. thanks for this video.. very helpful as I work my way through your VBA course. Thumbs up!
Thanks Wayne.
You helped me with this tutorial. Thank you very much!
You're very welcome Glorimar.
Thanks Alan, great video, though I am still long way from finishing your course on VB
Thanks!!! Great job!
Good Stuff!
You're welcome Jaime.
Great Video, Alan - I've learnt a lot from it. Thumbs up!!!
Thank you Michal.
Super helpful!! Thanks!
Your welcome my friend.
Thank You, Alan
This is usefull information.
Great! My pleasure, Frankie 👍
Super helpful.
Thank you Jeffrey.
Hi
I copied letter by letter the last macro and , il gave me compile error.
I would like to know how to access the library of color
Thanks
Hi, thanks for your videos. I ask you for help on the vba interface. The right edge of the page where the code is written, where the icons appear: bookmark (in blue), breackpoint (red) and pause debug (in yellow). This border has disappeared and I can't restore it. Can you help me?
Sir, At 5.35, in your video, how the yellow arrow is appearing to manually run the code, what are the keys to activate ? I am not clear at this juncture.
That is the F8 key Karunanithi.
@@Computergaga Thank you Sir.
Did not understand the paramter u aresupplying into the changecolor function... can u pls explain? is it the RGB value?
Not the RGB value, although that is possible as an alternative way to set the colour. This is the color index.
I found out what the number was before the video by assigning the colour to a cell, and then in VBA testing what the colour of that cell was.
Hi dear sir I hv query in excel....I want a value which is located in my sheet1 when I put formula I could get its cell address ....like a finder works.. I m trying it from this formula =CELL("address",INDEX($A$18:$A$24,MATCH(A26,$A$18:$A$24,0))) but in this formula hv limitations of criteria...if I increase it’s criteria than it’s not working ......help me ....sir I want data is located anywhere in the workbook when I put the formula I could get the results that’s value addresses....help me
I think this is what you want Rakesh. A VLOOKUP to return a cell address - th-cam.com/video/TKcdtSmZvyo/w-d-xo.html
Computergaga sir but in vlookup the value columns range will be defined than we can get the results....but in my case columns ranged will be not defined..... I hv lots of name in my sheet1 in different columns &I can change it’s columns as per my desired columns....I think it will be only on vba.....
Yes i think so. That confused me. But if it is like you say VBA may be the solution, or INDEX MATCH
Computergaga sir can u write a formula for it...
I don't completely understand your scenario, but here is an INDEX & MATCH video which may help - th-cam.com/video/SM2TbkdFkpg/w-d-xo.html