Advertisements I am trying to filter out all results on Column 5 except for one called "Pending". Often, there are no "Pending" variables on the report, so I should be left with only blanks and column headers. Every time I run the code though, it returns a single result showing a variable called "Inactive" which… Read More How do I filter to allow only one variable AND blanks?
Advertisements I am trying to filter out all results on Column 5 except for one called "Pending". Often, there are no "Pending" variables on the report, so I should be left with only blanks and column headers. Every time I run the code though, it returns a single result showing a variable called "Inactive" which… Read More How do I filter to allow only one variable AND blanks?
Advertisements The Excel VBA code is using a regular expression to extract section numbers from HTML files. However, the regex includes a negative lookbehind which is not supported in VBA regex. "(?<!tbl"")>(\d(\.\d)+)<" Sub GetAllSectionNumbers() LRb = Cells(Rows.Count, "B").End(xlUp).Row Range("B7:C" & LRb).ClearContents Dim fileDialog As fileDialog Set fileDialog = Application.fileDialog(msoFileDialogOpen) fileDialog.AllowMultiSelect = True fileDialog.Title = "Select… Read More How to handle negative lookbehind in Excel VBA regex?
Advertisements i’m trying to update a sheet depending on values in another sheet. I made 2 lists, with each one linked to the other. but when i increment one list is going to a cell +1 and the other one is incrementing occrectly. Here is an exemple. B16 = ‘PL_GROWTH(CUSTOM)’!CN88/1000 C16 = ‘PL_GROWTH(CUSTOM)’!CN99/1000 D16 =… Read More vba – increment through 2 list at a time
Advertisements The code below is provided to show what I need to do, but I find that I cannot successfully copy the contents of the Right Header to the clipboard with VBA no matter the method or how short or elaborate the code. Maybe it just can’t be done? I am trying to avoid using… Read More Copy contents of Excel Right Header to a cell
Advertisements I want to partially color the fourth column of the table object Sales after the 3 to the end to vbBlack. Currently, the entire column name font color is white. I’m trying the following, but it gives me an error saying an object is required. length = Len(Worksheets("Sales").ListObjects("Sales").ListColumns(4).Name) Worksheets("Sales").ListObjects("Sales").ListColumns(4).Name.Characters(Start:= 4, Length:=L).Font.Color = vbBlack >Solution… Read More Partially color the name of a listcolumn
Advertisements I need to lookup values on another sheet. My formula works great, when i use it manually =VLOOKUP(TRIM(C2),TRIM(‘MyDataSheet’!$A$1:$E$500),4,FALSE) However, I need to be able to plug this formula into a cell dynamically using VBA. This is what I tried: Set lookupRange = ThisWorkbook.Sheets("MyDataSheet").Range("A1:E500") Set newCol = tbl.ListColumns.Add newCol.DataBodyRange.FormulaR1C1 = "=VLOOKUP(TRIM(RC[-16])," & lookupRange.Address(True, True, xlR1C1)… Read More How to include dynamic VLOOKUP in FormulaR1C1 VBA?
Advertisements I’d like to copy like this. But, this is what I got My code is quite simple Range("C1:C2, D1:D2").Value = Range("A1:A2").Value I just want to copy several cells as a whole into several different places at once using Range propery like this. Does it has something relationship with Order of Operation ? I mean… Read More How to use Range property properly?
Advertisements I’ve written my code to run on the second row and now I want to let it run on the first 20 rows if I indicate column 23 with an "x". I can’t seem to make it work somehow: Dim i as Long Dim j as long Dim Seat as String i = 2… Read More Run code on first 20 rows if column is indicated as X
Advertisements I am trying to sort a VBA dictionary with the following keys and values. It is sorting the keys alphabetically. What I want is for it to treat the keys as "MMM-DD" format and sort. Is it possible? How do I make array list convert the keys to a date format (MMM-DD)? May-1 12… Read More Sort VB Dictionary with Keys in "MMM-DD" format