AboutPricing

Get instant live expert help on I need help with excel select only visible cells

“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

    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
    paste visible cells only when filtered data, i had try paste visible cells only but from that formula i did not get solution anyone can help??
    Solved by E. J. in 19 mins
    trying to copy and paste. want to copy and paste to only visible cells. i can copy, but when i paste, it pastes to the hidden cells too. how do i paste to only visible cells?
    Solved by K. H. in 27 mins
    How can I do a sumif formula on visible cells only
    Solved by B. B. in 19 mins
    I'm trying to paste an unfiltered column to only the visible cells of a filtered column. I'm using Excel 2016.20 on a Mac.
    Solved by A. W. in 12 mins