How To Hide Rows or Columns in Excel using VBA

preview_player
Показать описание
I am starting tutorials on Excel VBA. A lot of people are scared of coding and thinking it's very difficult. I'm here to make coding easy. You could follow the examples in these tutorials to become experts.

In this video, I'll show you how to hide columns and rows using VBA code when the value of a cell change. You could use other triggers to activate such an event based on your needs.

I have put a lot of efforts in making this video! I appreciate, if you could in return like and/or subscribe to support my channel! It does really help. Thanks! 🙏 If you have any questions, please let me know in the comments below 😊
👉 More related videos below👇
#BhupinderTube #excel #tutorial
Рекомендации по теме
Комментарии
Автор

I have put a lot of efforts in making this video! I appreciate, if you could in return like and/or subscribe to support my channel! It does really help. Thanks! 🙏 If you have any questions, please let me know in the comments below 😊
👉 More related videos below👇

bhupindertube
Автор

Sir please make video on students report card where not all students offer geography and how to hide the geography subject cell when a student is not offering the subject

Samsitex
Автор

Hi. I worked through your example on the rows and applied it to my problem and it worked perfectly so thank you. Is it possible to do add another routine on the same worksheet that will remove another set of rows based on a specific cell

derrickfowler
Автор

want to multiply the value in cell A1 by the value in cell B1 and display the result in cell B1.

girishsonawane
Автор

Hey mate!
Is it possible to hide columns B & D only?
I know you can hide multiple consecutive columns ("B:D"), but I don't know how you can hide multiple non-consecutive columns.
I would appreciate if you could help me! :)

ikghzph
Автор

Hi Sir, good day, need your favor and assistance, what about if I select cell A1 i need to hide rows (a2:a4) and if I select B1 I need to hide A5:A7. Your help will be much appreciated. Thanks

mauricelee
Автор

I want a VBA code for below
I have Budget report in that case users need to authorized that budget report on the same date. but they changed the date every time. I want to Count those changes
If user change the date. or he delete the date. then it should be count
If user enter date first time then it should count from 0 in cell A500 and after that if he change the date or delete the date then it will count 1 and its continue

girishsonawane
Автор

Well excel is easy but not all the time. So my question is the same as everyone else. Can you hide rows based on multiple cell Values?

stevengergi