vba

[ad_1] You should use conditional formatting. https://support.office.com/en-ie/article/Quick-start-Apply-conditional-formatting-6b6f7c2a-5d62-45a1-8f67-584a76776d67 [ad_2] solved How to color all the rows based on the cell values

[ad_1] Sub HideRows() Dim i As Long Dim j As Long Dim hide As Boolean ‘loop through rows For i = 9 To 54 hide = True ‘loop in the row: B through AF column For j = 2 To 32 ‘if we found value greater then zero, then we don’t want to hide this … Read more

[ad_1] Use following sub. I tested it and found working. Sub fBold() Dim UsedCell, MyRange, srcIdentifier UsedCell = Sheets(“Sheet1”).Cells(1, 1).SpecialCells(xlLastCell).Row Set MyRange = Range(“A1:A” & UsedCell) For Each intCell In MyRange If Not InStr(1, intCell.Value, “.”) > 0 Then intCell.Offset(0, 1).Font.Bold = True End If Next End Sub 1 [ad_2] solved How to recognize the … Read more

[ad_1] Using Excel.UserRange, loop through the rows and access the cells by ThisWorkBook.Sheets(1).Cells(row, col).Value. If you find the value to be null or nothing or empty string, then call your sending mail function [ad_2] solved Visual basic for excel or VBA

[ad_1] Try this out and let me know if it works for you.. This will provide you with the results shown in your picture. Sub SerialCode() Dim ws As Worksheet Dim startOf As Long, endOf As Long, data ‘startOf and endOf are Long for >5 digits. Dim lastRow As Long, currentRow As Long Dim dataRange … Read more

[ad_1] For me, doing it with VBA is easier. Sub CreateSubSet() Dim WsS As Worksheet ‘ Source Dim WsT As Worksheet ‘ Target Dim WsR As Worksheet ‘ Reference Dim Ref As Range ‘ the Id column in WsR Dim Id As Variant ‘ Id lifted from WsS Dim Fnd As Range ‘ Find Id … Read more

[ad_1] Using sum over countifs would give you what you are looking for. Like for example, assuming you have 200 rows, you may use: =sum(countifs(“A1:A200”,106, “B1:B200″,”EV MEDICAL SERVICES 2019”, “C1:C200”,{“890701″,”890602O”})) Notice the use of curly braces to add a list of comma separated criteria for filtering the last column. 1 [ad_2] solved Count multiple criteria … Read more

[ad_1] I’m not even sure I understand what you’re asking. select a value in excel and put some text or formula So you want to search for something than replace that with something else? (text/formula). Or just if it’s possible to change a Cells value? Start with the easier, change a Cells value or add … Read more

[ad_1] You say you want to ” look for exactly “5000” ” and then you look at xlPart in your code. If you want to match the value exactly you need to use xlWhole. More to your question, store the cell you find into a range variable and then reference off of that to replace. … Read more

[ad_1] As per your comment you want to loop through your range then try the below. This is just a for loop in VBA sub testcode() dim i as double dim yournametofind as string for i = 2 to 20 yournametofind = Worksheets(“DataValues”).Range(“A” & i).value if yournametofind = yournametofind then ‘do your things else do … Read more