Get instant live expert help on I need help with excel select 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
Hi, i need help with copying visible cells in an excel
Solved by O. F. in 23 mins
I just need a help to paste the visible cells in excel.
Solved by V. B. 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