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...
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...
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...
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 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.