I think that the first dim is just a shell with nothing in it. When you ReDim you’re telling the code the size of the array. When you ReDim Preserve you ReDim and keep what was in the first ReDim.
Nice video 👍👍. Plz share some video on tree view in Vba which is fully dynamic . Whatever I save in Vba that has to be created in form of file under treeview who I can access n modify.
I am copying data from one workbook to another but the sheet name in source workbook changes everyday. so how to create a dynamic sheet name in VBA to take the data from the source workbook. The sheet name change with the change in date.
Hi Sir, i need one clarity on if else condition through VBA If i have data in a column, i want to copy the data of active cell to next cell in same column until it finds blank cell. Once it look for blank cell, that should be deleted and again look for next cell. The process should be repeated until it finds the specific text like " total Sum". Once it look for the text it should select the entire row and delete and and then further step it can start as will be instructed. Can you help me through this
I am able to do it, but it is not repeating the step. It is working only for one time. I dont have limitation for the step apart from the specific text
The data will be like its a dummy Like in active cell value is 10000. I need to copy it down until blank cell. The next blank cells sholud be deleted entirely, blank can be one or any number of cells. In next non blank cell value can be 20000 , it should copy down until next blank. The process should be repeated until a specific text like " total sum". Hoping to get your help
Get Certified in Excel VBA:bit.ly/41fWeVP
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
I love your tutorials. Much better than other ones where their English is their first language.
It is wonderful work that you are doing here, you helped me with my university assignments!
Thank you so much!!
Thanks sir! Very explanatory and right to the point at the same time.
Fantastic style for explaining things...you guys are doing great job!!!
How are you touching that screen??? Are you using a smart TV or something ???
is it truely dynamic?we need to ad umlimited items as per demand..no size declared
Thank you for your great job, i really apreciate it.
Great videos. I appreciate the help!
you are doing a very great job sir, keep it up. Happy new year.
I understood Redim and Dim Preserve. Thank U
Thank you sir for your help ، have a good a day
When dynamic array is declared, what is the necessity of re-declaring the array.
I think that the first dim is just a shell with nothing in it. When you ReDim you’re telling the code the size of the array. When you ReDim Preserve you ReDim and keep what was in the first ReDim.
@@Rosini2222 instead of re-declaring array , we can change the index value in dynomic array..
@ashok sagar Thank you. That makes sense. Thank you for the insight.
@@Rosini2222 You're Welcome
Easy Explained.
very useful
Nice video 👍👍. Plz share some video on tree view in Vba which is fully dynamic . Whatever I save in Vba that has to be created in form of file under treeview who I can access n modify.
very helpful.
appreciated
How to read one complete row at a time from 2d array
Add Elements to a Dynamic Array Variable in VBA Using a Loop.?
How to redim preserve in the middle of a loop?
I am copying data from one workbook to another but the sheet name in source workbook changes everyday. so how to create a dynamic sheet name in VBA to take the data from the source workbook. The sheet name change with the change in date.
can we put some variable value inside ? (like Redim a ("i"))
Yes sir
Thanks for video and the answer
Hi Sir, i need one clarity on if else condition through VBA
If i have data in a column, i want to copy the data of active cell to next cell in same column until it finds blank cell. Once it look for blank cell, that should be deleted and again look for next cell. The process should be repeated until it finds the specific text like " total Sum". Once it look for the text it should select the entire row and delete and and then further step it can start as will be instructed. Can you help me through this
I am able to do it, but it is not repeating the step. It is working only for one time. I dont have limitation for the step apart from the specific text
The data will be like its a dummy
Like in active cell value is 10000. I need to copy it down until blank cell. The next blank cells sholud be deleted entirely, blank can be one or any number of cells.
In next non blank cell value can be 20000 , it should copy down until next blank. The process should be repeated until a specific text like " total sum".
Hoping to get your help
Why always using msg box with example using some cells like b3 a1
Thank you
Mast hai
THANK YOU
recording is too bad, all your videos are blurred, just change the Video and check before uploading
how can i contact u personally?
i got very complicated excel error in my excel and it can't explain here so please provide ur personal contact