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.

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