Тёмный

VBA to Hide and Unhide Columns on Conditional Basis - Excel VBA Example 

Excel Destination
Подписаться 45 тыс.
Просмотров 39 тыс.
50% 1

This Excel VBA Tutorials explains VBA code for columns Hide and Unhide. Also, how to Hide & Unhide Columns basis on conditions using VBA Macro.

Опубликовано:

 

29 мар 2019

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 39   
@crystalmendoza8140
@crystalmendoza8140 4 года назад
I don't know anything about VBA and I needed to get a task done at work. After some trial and error (user error, of course!) I finally got it working. I would have never figured it out without this video, thank you!
@ExcelDestination
@ExcelDestination 4 года назад
Great Job! if you need any assistance in VBA, you can write to exceldestination@gmail.com
@mxrvxn08
@mxrvxn08 2 года назад
This is a beginner friendly tutorial, easy to follow and well explained. Thank you so much
@ExcelDestination
@ExcelDestination 2 года назад
You're very welcome!
@frankpartida8685
@frankpartida8685 4 года назад
Awesome example. Very detailed and easy to follow. Thank You...
@jaswantdn7
@jaswantdn7 3 года назад
Thank you so much, Sir. You have reduced half of my tensions.
@ExcelDestination
@ExcelDestination 3 года назад
Excellent
@MohAboAbdo
@MohAboAbdo 5 лет назад
Thank you very much for this simple lesson and for this wonderful code
@MarcusViniciusFerreiravferre
@MarcusViniciusFerreiravferre 3 года назад
Saved my life! Thanks a lot!!
@ExcelDestination
@ExcelDestination 3 года назад
Glad it helped!
@ThePoolchick
@ThePoolchick 6 месяцев назад
awesome, thank you for this!
@TheMengdong
@TheMengdong 2 года назад
It is very helpful! Thank you very much!
@ExcelDestination
@ExcelDestination 2 года назад
welcome
@marks1603
@marks1603 2 года назад
Very well explained .... thank you!
@ExcelDestination
@ExcelDestination 2 года назад
You are welcome!
@jamesdiaz9740
@jamesdiaz9740 5 лет назад
Thank you, it's a good video¡
@harisuraj
@harisuraj 2 года назад
Super useful, Thanks
@hazemali382
@hazemali382 4 года назад
more than great
@preethamsshetty8425
@preethamsshetty8425 4 года назад
Thanks for the Video. Explanations were great. What if the 3rd command was to automatically execute whenever there is "A" in Row 1 without clicking on the button
@fabianosilvadejesus1382
@fabianosilvadejesus1382 5 лет назад
Hello! Great video! I have a doubt. I would like to know if it is possible to perform the hide and unhide column action on the same macro button? For example, Click once hidden, click again unhide. Thank you very much for your attention.
@WalterWhite-lq6tp
@WalterWhite-lq6tp 4 года назад
Yes, with and ActiveX toggle button
@nagadurgaande1413
@nagadurgaande1413 11 месяцев назад
In manually we can give value but in automatically how can we give
@krs218
@krs218 2 года назад
Nice video
@ExcelDestination
@ExcelDestination 2 года назад
Thanks
@minion1892
@minion1892 2 года назад
Hi, if don’t want to specify this macro to the current worksheet, how do we change the code?
@hemantkulharia2255
@hemantkulharia2255 3 года назад
need a solution want to hide rows but data is too large how to do it. Needs to hide the row as soon as we write down the word done in certain coloum for the same row ?
@ExcelDestination
@ExcelDestination 3 года назад
I can provide the customized code, that will do your task. Send me email at exceldestination@gmail.com
@williambeehag6166
@williambeehag6166 3 года назад
Thanks very much for the video. I have a problem you may be able to help me with. I have a tab which is formulated to produce a short sentence from data input on previous tabs. If select Yes then sentence is formed on comments page & if left blank then formula for the sentence returns a “FALSE” reading. I would like to hide the rows that remain “FALSE” on my comments page through a button. Are you please able to help me with this problem? Much appreciated. Bill
@williambeehag6166
@williambeehag6166 3 года назад
Anybody able to help with this question? Would be much appreciated
@rajeevdixit7019
@rajeevdixit7019 3 года назад
I want unhide columns which are written part
@akio6505
@akio6505 3 года назад
Thanks! Can I hide rows based on the name of the person who opens the sheet? I have one master file with 30 people who will enter their scores but i only want per person to see his assigned rows only.
@ExcelDestination
@ExcelDestination 3 года назад
yes, absolutely. But, for that you would be required to write additional code.
@akio6505
@akio6505 3 года назад
@@ExcelDestination thanks. Can u share the starting point?
@sanketnarkhede2585
@sanketnarkhede2585 3 года назад
If I have to hide multiple columns using variable, how I can do it
@ExcelDestination
@ExcelDestination 3 года назад
some additional code would be required.
@tarunmalhotra6750
@tarunmalhotra6750 Год назад
Hi I have a table In Excel wherein Column B have sheets name like 1 2 3 etc and Column C11:G40 has data validation conditions Yes or No. I wants to make Visible sheets if in Column C:G if its Yes and else if its No hide sheets. Can you help on writing this code.
@kachachandresh306
@kachachandresh306 3 года назад
i want blank rows hide in selected range how
@bijalagrawal6097
@bijalagrawal6097 3 года назад
I want to hide the columns or row, but when i want to unhide it, the password should come first, how can i do this ?
@ExcelDestination
@ExcelDestination 3 года назад
You can take some help from another tutorial for using password through VBA. Link is : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AE3R5WGgdJc.html
Далее
How to get the Last Row in VBA(The Right Way!)
15:41
Просмотров 153 тыс.
Excel VBA - Rows Hide and Unhide
3:04
Просмотров 96 тыс.
Next Empty Row Trick in Excel VBA & Macros
10:36
Просмотров 52 тыс.
Excel VBA: How to Sort Data with VBA Macro
8:37
Просмотров 101 тыс.
Creating a Checkbox to Hide and Unhide Rows in Excel
5:39