Welcome to my channel where you will learn Microsoft Excel VBA from Basic to Advance level, VBA Tricks & Tips. You will learn how to use VBA for process automation so that you no longer have to do recurring tasks manually.
Subscribe to my channel if you would like to learn & improve your VBA skills.
Link to my Playlist: ru-vid.com/show-UCfkw4_avSd_ZDdZ_TL1s_lwplaylists?view_as=subscriber
Ok good, but I noticed that when I use only pathname variable; the code runs successfully with no need to foldername variable or DIR function! Dim PathName As String PathName = "C:\Test" If PathName <> vbNullString Then........
Hi, I have a unique request. What if you had two sheets, Sheet1 and Sheet2, and they are identical. Is there a way to have an active macro that runs without intervention, where rows in Sheet1 is hidden based on a column in Sheet2. Sheet2 cannot be altered with any rows hidden but serve to be the base line. Sheet1 will only show the rows that meet the criteria of <> than 0 based on a column on sheet2. So if row 2 on Sheet2 has a variance <> than 0 then line 2 in sheet1 will be visible. if the cell value of row 2 sheet2 changes to = to 0 then row 2 in sheet1 will then be hidden, without any human intervention. It should happen dynamically and active. Is this possible?
very impressive work, i have a question, how i can create a table of contents with chapter numbers, headings, sub headings in excel or in word with the help of such code or macro, can u please guide me?
Hello - I also come across error 462: the remote server machine does not exist or is unavailable. This happens after looping (the first run-through works perfectly)
I followed the same procedure and path but is is fetching data of only one word file. Remaining word file details it is not fetching. Can you help me on this.
I want to copy the excel range to send an email respect to the current date. Example: The table range is A1:D20 Column A for Date. Now I want to copy the range A5:D9 to send an email body, A5 to A9 cell value are current date. Please share me the VBA code in this regards.
Hello sir, Very smoothly you delivered the content. Sir can you please me a public function for Text formula Criteria is i have 12345 data len of the cells is 5 or 6. I need output in 7 len =Text(a2,"0000000")
Thanks Naresh. You can definitely use this msgbox for any other VBA code. If you want to make any combo box visible, you can use code like "Sheet1.ComboBox1.Visible = True" (where Sheet number & Combobox number will be based on your excel file/ requirement).
How does this work in real life when the first tab isn't the list of names to change? would i then have to add a new worksheet just to have the names? what if the tab names you want to change aren't in the first tabs and start by the 3rd tab?
Thanks for the question. You can see this short video which explains how to do hide rows based on cell value ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-8W4fiHtPR1Y.html