Auto Hide Row!!!

M

MarkReddell

Board Regular
Joined
Sep 1, 2011
Messages
210
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hello Everyone! I need to know if it is possible in VB to have a macro to do auto hide rows based on no data in a range of: a5:u30000. Thanks 4 any help!!! And auto show rows if range: a5:u30000 has any data!!! :confused::confused::confused:
 
Last edited:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
You must log in or register to reply here.

Similar threads

Red over White
  • Solved
Filter by specific days, months and years
Replies
3
Views
254
Red over White
Red over White
Y
  • Question Question
How to automatically hide/unhide columns based on related month with VBA
Replies
1
Views
309
ysfuyar
Y
N
  • Question Question
Hiding rows based on cell value
Replies
3
Views
2K
ninjapaping
ninjapaping
J
  • Question Question
Macro Button
Replies
3
Views
314
Sektor
Sektor
J
  • Question Question
Hide Rows with a Checkbox
Replies
1
Views
170
Eric W
Eric W

Forum statistics

Threads
1,223,275
Messages
6,171,126
Members
452,381
Latest member
Nova88

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top