AboutPricing

Get instant live expert help on I need help with vba find value in range

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.
< Go Back

    Here are some problems that our users have asked and received explanations on

    vba to save all sheet in a workbook to csv with range and exclude value 0
    Solved by S. B. in 12 mins
    In VBA for Excel 2016, I am puzzled why 'Range(Cells(3,6)).Value' gives an error whereas 'Cells(3.6).Value' does not.
    Solved by G. D. in 24 mins
    Can you simplify this formula for vba? Sub Test() Dim LastRow As Long Dim i As Long LastRow = Range("A" & Rows.Count).End(xlUp).Row For i = 2 To LastRow If Range("A" & i).Value = "CANCELLED" Then Range("N" & i).Value = "," & Range("N" & i).Value Range("O" & i).Value = "," & Range("O" & i).Value Range("P" & i).Value = "," & Range("P" & i).Value Range("Q" & i).Value = "," & Range("Q" & i).Value Range("R" & i).Value = "," & Range("R" & i).Value End If Next i End Sub And skip if blank.
    Solved by M. E. in 16 mins
    I need help with VBA Code. Private Sub OptionButton2_click() If OptionButton2.Value = True Then Range("B4").Value = "Alaska Airlines" End Sub
    Solved by D. C. in 15 mins
    I need a formula to find the range of matching values in a column. I can use MATCH to find the first matching value, but am having difficulty finding the last matching value. I am trying to create a dynamic range for subsequent vlookups.
    Solved by I. H. in 30 mins