วีดีโอ

This is good stuff!!

Sir, is there any way to apply Strings.Filter method in 2 dimensional array in Excel VBA? I want to filter array on single or multiple conditions. Or, you can say, I want to store data into The Final Array (ActionFilmDetails) that meet the Condition (Single or Multiple). I've written the below-mentioned code. But, I can't understand, why this code gives me "Run-time Error'13': Type Mismatch" Error? Raw Data: ID Title Released Date Length Genre 001 Marvel's The Avengers 04-May-12 143 Action 002 The Dark Knight Rises 20-Jul-12 165 Action 003 The Hunger Games 23-Mar-12 142 Adventure 004 Skyfall 09-Nov-12 143 Action 005 The Hobbit: An Unexpected Journey 14-Dec-12 169 Fantasy 006 The Twilight Saga: Breaking Dawn Part 2 16-Nov-12 116 Awful 007 The Amazing Spider-Man 03-Jul-12 136 Action ============================ Code: Option Explicit Sub CopyActionFilmsOnly() ThisWorkbook.Save Sheet3.Range("G1").CurrentRegion.Offset(RowOffset:=1, ColumnOffset:=0).ClearContents Dim LastRow As Long LastRow = Sheet3.Range("A1").Offset(RowOffset:=0, ColumnOffset:=1).End(xlDown).Row Dim LastColumn As Long LastColumn = Sheet3.Range("A1").End(xlToRight).Column Dim FilmDetails As Variant FilmDetails = Sheet3.Range("A1").Offset(RowOffset:=1, ColumnOffset:=0).Resize(RowSize:=LastRow - 1, ColumnSize:=LastColumn) Dim RowCounter As Long Dim ColumnCounter As Long Dim ActionFilmDetails As Variant For RowCounter = LBound(FilmDetails, 1) To UBound(FilmDetails, 1) For ColumnCounter = LBound(FilmDetails, 2) To UBound(FilmDetails, 2) If FilmDetails(RowCounter, 5) = "Action" Then ActionFilmDetails(RowCounter, ColumnCounter) = FilmDetails(RowCounter, ColumnCounter) Else Rem Nothing is needed to do End If Next ColumnCounter Next RowCounter End Sub

Very nice

Could you please add some videos on the Macbook file dialog functions? thank you in advance

Thanks

Edit: At 1:57, I mention String is a Primitive Data Type. This is not entirely correct in VBA. A String is a LIST of individual characters which makes it a Composite Data Type. But, then again, we can't declare a Variable as a Character in VBA. So, the exact classification of a String in VBA is a bit murky. In other languages, String is clearly NOT a primitive data type. I talk more this in the lesson on Strings.

The best videos always ❤

Excellent ❤, keep up this good work

every one like video

thank you for continuing series

Please do a tutorial on how to automate a cashflow statement monthly using the income statement and balance sheet.

My favourite channel

Yet another great tutorial...I'd be a happy student if you were my tutor. Look forward to the next one😂

thank you! very useful

Great compositional breakdown to the nucleus of objects.

I wish people would stop pronouncing "Parameters" as para-meters. Its pronounced "param-meters". A double m is silent....grrrrr

Excellent video. Thanks for sharing and keep up this excellent work❤👍

Please do mapping for a cash flow statement example using trail balances

Hi, Pl guide. In the 2nd line in 'Else' section of 'If' statement for creating Storename Array, Redim is used without 'Preserve'. However, the array doesn't loose values assigned thru 'If' condition in previous iteration. Kindly guide how. Pl. advise if I am missing something to understand.

thank u bro, nice tutorial

good explanation of the project in perfect way able to understand the vba coding thank u bro

Nice tutorial

thanks for video and your work and please keep posting video

My Code is not implementing in project.

Excellent, can share source code?

Excellent video. Thanks for sharing

👍❤

Excellent. 👍Thanks

Another good one...some good teaching skills demonstrated here

Thank you for this playlist

Another excellent tut

thanks sir ji for video, please keep continue VBA master class

Hi there, If you possible , could You explain really time database related project using macro code Because I asked lots of questions of people no has not been answered

Please post weekly. I love this channel, extremely informative examples

ur a great teacher....iam lucky that finnaly i found this playlist......before i directly went to the projects playlist ..now i am here for basics then i will go there: note : i read a saw 10 basics videos already from some other channel in hindi ... now this is my second prepration

these projects are pro level projects

Please do more examples

this is good stuff.

Sir i need your help for create a cutting optimization program.

Thanks for the Video. It was very helpful. Just as an fyi, you forgot a line in the first script. oAttach.SaveAsFile sAttachName

This is like art, nice

Superb work that is of great help. Just having a run time 13 error when some of the item IDs are numbers and some are alphanumeric e.g. L7878. Any idea where I change the data type?

Brilliant, thank you!!

this is the best video i have ever found .....the only thing i regeret iti found this video in 2024 means after 3 long years..........thank you for making such valuabe video ...thankyou

Please post more accounting content

I found this case study extremely useful, very comprehensive and complex. Please post more case studies accounting and finance related

Superbly talented sir, simple with zero level 100.

hello , I tried to add the wsOut.Cells.Clear into my code but it says"The Varible is not defined" what might be the poblem?

thankyou sir ji for your effort teaching

thank you sir from Zimbabwe