Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)

I like how you teach. In fact, I'm enrolled in your Power Query Course. I'd assumed that you also have a Excel VBA course right? I'd like to learn macros.

omg. I'm not getting much sleep. I keep learning more from you and instead of fixing the basic stuff I have written, I am thinking of other things I can do! Thank you :-)

hello, how I select a range that is not defined?

you are great, really it interesting video

Hello, very interesting all your videos. Why don't you make videos in Spanish? It would expand your audience by many millions.

Madam, Please share Video on ""Send bulk emails with dynamic table range without using filter function in VBA""

Hey Leila, thanks for your videos. I need to loop through a range (one column) and 1) check if the cell contains a specific text/string and 2) if true, write the text in a new cell (same row). Which of your tutorials do you recommend to watch? Also, I didn't find the next video/lecture you mentioned at the end of this one. thank you in advance

how to recreate an excel sheet using VBA, all content and formatting

Hi, i need a help....how can i make range a varible insted of using Range("A1:D4") ...i want A,1,D,4 all must be daynamic variable
kindly support

Thank you for teaching the basics!!!!

Super🐊

Excellent video. You are great instructor, and the video is top-notch in clarity.

you are good.

In Spanish-language there's not channel like this one. Great, you have a nice voice, even my native language is Spanish, i get all you explain. I just founded you. Congratulations "Desde américa Latina, Nicaragua. Saludos"

How to do vlookup using VBA?

بهترین استادی👏👏👏

Hello can i get help with this. i'm finding for a string with "net.ipv6.conf.all.disable_ipv6 =" where if it will be 0 value will get msgbox "no" but if value is 1 will get msgbox"yes" thank you.

Just figured out my error: I named my module Cells which started this whole mess! (I left my question for anyone else's benefit)>>>>Thanks for the work you put into this video Leila, quick question: When I tried to use your second example: cells(1,1)="1st" it gave me an error: Compile error: Expected variable or procedure, not module. It's like vba isnt recognizing that expression because it's not even suggesting anything when I type the "cells(" part....... Thanks for any help.

How do you reference named ranges that's not in the active sheet? I tried putting sheets("sheetReferenece") before the range method but I always get a "Application-defined or object-defined error".

Hi there, what is the best way to store, catalog, index VBA code/ projets codes...

Hi Leila! How can I used the same macro in one excel file for the next column without changing the numbers of the other columns while I m using the same spreadsheet day by day.
Let’s says the column are for day 1,2,3 and so one.

thanl you so much

Not sure if you offer help to folks but here goes. I have a range of values I created a dynamic distribution chart for that updates as I enter values, that range values from 2 through 12. The chart gives me the total number of occurrences each time any of the values appear. The total number of rows with these values is 5000. I want to create a supplemental chart that tracks just the last 50 entries in row order as data is entered. This supplemental chart will always give me the last 50 rows of data. Is the presentation posted here the best method to achieve those results? Thanks for any advice. Great value here.

Hello Leila sorry to bother but the following command doesn't work for me : Range(“A” & 6,”C” & 6)= “6th”
I got run time error 1004. What i am doing wrong ?
Thanks for your help

I have a question, Can you concatenate a range first Cell reference?

would you please describe how to select and choose different columns wich are not next to each other at once (for ex as if you want to enter and refer two different ranges in separated columns in a linest function at function tab)

Amazing 👏 that was full comparhansive explanation 👏
I appreciate that efforts from your side


This is was very helpful

Very nice presentation
Look forward to your course

Great lecture, easy to follow.

Outstanding presentation. Thank you.

Thanks!

impressive teaching ability , right pace and right details . subscribed !.

VBA allows to specify ranges using the short notation with square brackets instead of the Range() or Cells() property. For instance 'Range("A1").Value' can be written in short as '[A1].Value'. This is also true when using areas, for instance [A2:C2].Value = "2nd", and named ranges such at [LastOne].Value = "10th".

its not working for me Range("A"&7)="7th" - Syntax error

She is the best

Used this techniq and solved a issue for which i am looking for a solution in long time. Keep rocking😎👏✌

so well explained. Thank you

HOW TO COPY SELECTIVE CELLS FROM ONE SHEET AND COPY TO SELECTIVE CELLS OF ANOTHER SHEET?

You explain concepts very well and it is easy to follow. Thanks

excellent review!

on the sample you gave, why you can go to fill after last row? I dont see you out Last Row coding

Vangelis Nice

thank you very much

Hi, from your example: Range("A" & 6, "C" & 6 ), Can I select multiple cells but using cells(r,c) example cells(1,1) and cells(1,6) . I want to select only cells 1,1 and cells(1,6). how to do it?

Your videos are very informative. How do I reference entire rows as variables? For example if I am using them in a For/Next loop, instead of typing Rows("9:9").select? I can't figure out how to put a variable J in place of the 9's. Thank you.

thanks thanks thanks

Thank you.

Hey, maby Are you know, how can I use the Filter Function, but I want to fix one Cell of description, and this description I have to show always, if I use the filter function?

How to fit web cam live image fit in to excel sheet in vba..Madam pls help me in this topic