hidden row

  1. N

    Combine two Worksheet_Change in one Makro - VBA

    Hello, I'm really new to the VBA world and I'm currently trying to create a form which can be filled out. I got pretty far already but now I'm stuck. the problem is that I don't know how to combine two makro's under one Worksheet_Change. So i do have this existing makro which is working...
  2. K

    .ListRows.Add doesn't shift my hidden row

    I'm having a little issue with the following VBA code interfering with my hidden row(s) Sub macAddRow() Dim loTbl As ListObject Set loTbl = ActiveSheet.ListObjects("Table1") loTbl.ListRows.Add End Sub Here's the problem. Let's say Table1 takes up the space A1:D5. I have data...
  3. L

    Amending Upper case macro to exclude hidden rows

    Hi there, Can somebody please help amend my macro so that it ignores hidden rows? I have been playing around with some code but have not got it quite right. I know it is an easy fix I am just a noob. Here is what I have so far: Sub Selection_Uppercase() For Each x In Selection...
  4. K

    Pivot Table - Show Value As - Hidden / Visible Row

    I have two pivot tables, both tables have dates in one column and other column is the % difference from the top oldest date. I added a slicer to control both pivot table dates which works fine. Say the slicer is currently on 1/1/2017 and the prices are show % difference from 1/1/2017, now when...

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