Excel VBA Advanced Tutorial

Hello, I've tried to do filed 11 & 12 but for some reason my macro of SortLastCol have a problem and also my GenRep anyone can help me please ?

is this expert level???

MEINE FÄHIGKEITEN IN VISUAL BASIC SIND EINFACH ABSOLUT PERFEKT, TADELLOS UND MAKELLOS IN HÖCHSTEM MASSE! DIESES VIDEO IST WIRKLICH BRILLANT, FANTASTISCH UND GROSSARTIG! ICH DANKE IHNEN SEHR, SEHR VIEL!

Thank you sooo soo very much

I just finished the video. On to the Expert video next.

All good but exercise files seem to have been deleted, don't open at all

I really like this instructor. She's very engaging.

Great tutorial!

Hi, is this tutorial the follow on from the beginner tutorial, there isn't an intermediate?
Amazing work by the way, these are great!!

Amazing content! You made it look so easy to understand. Thank you!

DIM doesn't mean declared in memory, it means dimensioned.

My code: Dim aPrice As Integer. After running, the result is $2, it does not match with the initial data in cell H3 = $1.5. Can you explain it for me? Thank you

have just finished learning it was pretty fun to do

Tyvm for this tutorial :>

Thanks very much for the lesson! It was absolute perfection! Despite being extremely difficult, I successfully persisted and have mastered perfectly!!!

Teaching is super clear. Accent is also not making me sleepy.

This is perfect for those who are familiar with excel but want to start learning VBA.

Once you got the hang of the basics, you can simply use record macro, edit it to see how the code looks like and utilize into your VBA.

I ended up on this video ....while searching object and variable difference....and am glad that it gave me more than that!!!!

The voice of this tutur will always remain in my memory,. How she beautifully explained each items.....

I wish I had more videos of her on all Excel topics

Excellent video and perfect examples. I have learnt just watching from these videos to almost master vba and create very complex macros. Thank you Chelsea for the great job you do and I'm looking forward watching the Expert tutorial

The URL for the files in the video "Cannot be found"

I am incredibly grateful for the creator of this course content.

Such a brilliant course. The trainer is amazing!!! Its unbelievable that such content is free.

Wrong: Boolean is one bit, not two bytes but depends on the platform. And 8 bits form one byte.

hi,
you can try below code for example considered under example No. 10

Sub mytry1()
Dim x As Integer
For x = 1 To Worksheets.Count - 1
Worksheets(x).Select
Range("A1").Select
Selection.End(xlDown).Select
Selection.CurrentRegion.Copy

Worksheets("Aggressive").Select
Range("A100").Select
Selection.End(xlUp).Select
If ActiveCell <> "" Then
ActiveCell.Offset(1, 0).Select
End If
ActiveCell.PasteSpecial

Next x

Worksheets("Aggressive").Select
Rows("1:3").Insert
Range("A1").Select
ActiveCell.FormulaR1C1 = "Our Global Company"
Selection.Font.Bold = True
Selection.Font.Size = 16

Range("A3").Select
ActiveCell.FormulaR1C1 = "Symbol"
Range("B3").Select
ActiveCell.FormulaR1C1 = "Open"
Range("C3").Select
ActiveCell.FormulaR1C1 = "Close"
Range("D3").Select
ActiveCell.FormulaR1C1 = "Net Change"
Range("A3:D3").Select
Selection.Font.Bold = True
Selection.Font.Size = 12
Selection.Font.Color = vbBlack
Selection.Interior.ThemeColor = xlThemeColorAccent1
Columns("A:D").AutoFit
End Sub

Simply amazing contents

interesting content. question it did not give error @ 19.45 because intRow was declared as inRow with missing t ?

Amazing content!!

I want to creat a macro where it shows me the number of pdf that are sign digitally in a particular folder do you know where I can get this support ?
Mine is getting an error...

Thank you :D

Great content. There are not word to describe how amazing it is.

In Sub procedure NumberaVariable(), you should daclare the aPrice variable as Double since the Price is Decimal Number, not Integer. Otherwise, It will round up to an Integer.

Super-nice! Thanks! The only thing that could be better is the image quality. On my screen things get blurry, which makes me tired. But the suggestions for other videos on the right-hand side are razor-sharp, isn't it ironic!

Great tutorial, thank you. But there seem to be the "intermediate" module missing from this series. Is that intentional? If not, where can I find it please? Thank you

Just so you know Dim is not an acronym. It is short for dimension. You are dimensioning the amount of memory need by the variable type.

Instead of the macro to find the date, you could just use the "worksheets(x).usedrange.copy" function

There seems to be an issue with the exercise file link provided. It says it can't be found.. :( Excellent content with great pacing, explanations though.. keep it up!

awsome

best

Hi, for the End, Address, Call Statement exercise, why do we need the code :

datastart = ActiveCell.Address
Range(datastart).Select

under the sub FindData ()

as the macro still runs well and provide us the format that we wanted without the two rows of code above.
Thank you in advance for your time.

One thing I've never understood is the value of cells being in bytes. Surely all computers can handle these large amounts of information as nowadays memory of computers is in terrabytes.

Hi,

i have the same problem, but in my case, the master worksheet has a floating number of rows (depends on projects), i made button to automatically make the sheets depending on how many items are there in the master worksheet,

so, i need to copy the 6th row information from master sheet to 1st slave sheet 6th row, and then copy 7th row values from master to 2nd slave, and so forth.

do you now any way that i can do this?

If I meet this video first then I don't have wasted my money on the course I am on right now.... sad

Thanks for your great tutorials!
Few critic points I have:
-using the selection object often leads to mistakes and longer runtimes, and can almost always be avoided. Imo, it would be better to mention that in the beginning of the video.
-using "x" as a variable is not very telling, "spelling" names are better, like "intTemp" for temporary integers, or "intCurrentRowTemp" for filling rows in a for-loop
-it is very important to do good (!) commenting which could be added inbetween cuts, just to show how its done

Other than that, this is easily the best tutorial I have seen so far. Easily followable with a red line throughout the whole tutorial.

In the For Next Loop Doubled its writen dim inRow not intRow. You use intRow in the loop. Code is working ok. How is that?

Chelsea, I think you do a really great job. You are the best. Keep up the good work. I'm a 79 year old coder who's been at it for 50+ years, so I've sit through lectures.

Could it be that the inputreceived function no longer works in the current version of excel?
It keeps telling me I have to define it as a variable.

Nevermind!...i found how to unlock it.
i right clicked on the file then on General tab went to the bottom and clicked on trusted source.
thank you for your lectures!
finally learning a lot after a long time of struggling with VBA🥰👍👋