How To Hide Rows or Columns in Excel using VBA

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ต.ค. 2024

ความคิดเห็น • 12

  • @bhupindertube
    @bhupindertube  ปีที่แล้ว +1

    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👇
    👉 All Excel VBA Tutorials - th-cam.com/play/PL6oDA8S3RmtFlO7tSvUkUjVQaPjxg5yLN.html
    👉 Change cell value based on selected cell by using Excel Macro VBA code - th-cam.com/video/RTrhY70xJ3I/w-d-xo.html
    👉 Passing Arguments by Value and by Reference in Visual Basic Excel - th-cam.com/video/QQFiuQESmck/w-d-xo.html
    👉 How to get Developer Tab in Excel - th-cam.com/video/VYF0hjKajt0/w-d-xo.html
    👉 Microsoft Excel quick Tutorials (playlist) - th-cam.com/play/PL6oDA8S3RmtGgzDX8zwFlWi4bZH8WmUYN.html

  • @Samsitex024
    @Samsitex024 2 หลายเดือนก่อน

    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

  • @derrickfowler5172
    @derrickfowler5172 2 ปีที่แล้ว +1

    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

  • @shnoda1000
    @shnoda1000 ปีที่แล้ว +1

    you are the man, most appreciated

  • @ÁngelRusso-b8n
    @ÁngelRusso-b8n ปีที่แล้ว +1

    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! :)

    • @bhupindertube
      @bhupindertube  ปีที่แล้ว +1

      Hi. If you watch from 5:39, you can see that I've hide only one column. So, to hide more individual columns, simply keep adding new lines jus as Columns("D").Hidden = True and the opposite on the else part. You can add as many individual columns as you want. All the best! Please don't forget to like and subscribe to support my channel 🙏

  • @girishsonawane4671
    @girishsonawane4671 5 หลายเดือนก่อน

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

  • @mauricelee2219
    @mauricelee2219 3 ปีที่แล้ว

    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

    • @mauricelee2219
      @mauricelee2219 3 ปีที่แล้ว

      @@bhupindertube Many thanks to you, sir.

  • @girishsonawane4671
    @girishsonawane4671 5 หลายเดือนก่อน

    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

  • @stevengergi6781
    @stevengergi6781 ปีที่แล้ว

    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?