This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / 请教EXCEL高手们一个问题：how to paste in visible cells only?For example: Row 2,4,6,8 are hidden. Now you will see row 1,3,5,7,9,10,11...I need to copy the contents of E21 to E24 and paste them to A1,A3,A5, A7. However, if I click on A1 and paste, then the contents will be pasted in A1, A2, A3, A4, not the visible cells.
Does anyone know how to paste visible cells only? If VBA code is needed, could you please attach the code here? Thanks a lot.
-raindot(龙马精神);
2012-2-17
{391}
(#7293981@0)