Get instant live expert help on I need help with excel vba value2

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

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

hi i am looking for vba expert . i need to modify an vba excel file.
Solved by X. E. in 21 mins
Sub pdsch() lr1 = Sheets("DATA_METRICS").Range("A1048576").End(xlUp).Row Dim y1 As Integer Application.ScreenUpdating = False Sheets("Graphs_Rawdata").Visible = True Sheets("DATA_METRICS").Visible = True y1 = 22 For i = 3 To lr1 Sheets("DATA_METRICS").Select If left(Cells(i, 1).Value2, 4) = "SNGL" Then thru Cells(i, 1).Value2, y1 y1 = y1 + 23 End If Next i Sheets("SNGL-thpt-chart").Select Sheets("Graphs_Rawdata").Visible = False Sheets("DATA_METRICS").Visible = False Application.ScreenUpdating = True Cells.Select Selection.Clear Sheets("Main").Select Range("o5").Select ActiveCell.FormulaR1C1 = "COMPLETE"
Solved by Z. Q. in 21 mins
I need a formula for comparing 2 values and if value1 is bigger than value2 the cell states yes and if it is smaller it says no
Solved by V. B. in 25 mins
VBA Excel. I have request from my boss to have a button on the VBA Excel Form to print a work order and put the Equipment Name that is on the VBA form in the Work Order (a word doc) and print it.
Solved by F. F. in 26 mins
i need help with VBA is this included and are all operatives experts in VBA and not just excel
Solved by X. Q. in 23 mins