-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vba;
-
M
How to set an importance value of multiple variables?
Hi guys. I'm a bit new in VBA coding, but have worked with Excel a lot. I have this Claim sheet I am working on. And I need the Claim Importance to show (Low, Medium, High) on multiple variables. My formula right now is...- Miltoft
- Thread
- if formula matrix formula vba;
- Replies: 0
- Forum: Excel Questions
-
N
Horizontal Lookup Name Search
Hi, I do hope somebody can help me. I have 2 sheets... First Sheet Section 1 Fred Bloggs 1001 1003 1005 1007 1009 Section 2 Amy Trams 1000 1002 1004 1006 1008 Second Sheet 1002 9.2 0.00% 1 <section name="" here="">1005 9.7 80.00% 2...- nutrastat
- Thread
- room section sheet systems vba;
- Replies: 8
- Forum: Excel Questions
-
F
Filter Multiple Pivot Tables on Different Sheets Having Different Sources
Hi Allz, I had help from theBardd to filter multiple Pivots having different sources with one click on a Slicer in this thread. But can any one please help to adjust the following code to link it with a cell instead of a slicer? Private Sub Worksheet_PivotTableUpdate(ByVal Target As...- fiberboysa
- Thread
- dim filter; multiple nextrow pivot tabel vba;
- Replies: 0
- Forum: Excel Questions
-
P
Can't Enter Break Mode at this time
Hi, I am trying to add code to the sheet, which is dynamically getting created, when i a executing the subroutine, am getting the error "Can't Enter Break Mode at this time" at xLine = .CreateEventProc("Change", "Worksheet") and folling is my code Sub AddSht_AddCode(ByRef wb As Workbook)...- pradee
- Thread
- dim end set vba; xline
- Replies: 5
- Forum: Excel Questions
