none
Sheet Display Problem RRS feed

  • Question

  • I have a simple macro which copies a row down to the row below.

    Of course, soon the visible sheet display is full!

    What macro command(s) could I use to force the visible sheet display to always have exactly 10 empty rows at the bottom?

    Excel 2016.  Thanks


    • Edited by jophant Sunday, June 11, 2017 4:05 PM
    Wednesday, June 7, 2017 2:47 AM

All replies

  • Hi,

    Excel 2016 (32-bit) can use 1,048,576 rows.
    So you should stop copying on rows (1,048,576 - 10).
    ____________
    Ashidacchi
    • Proposed as answer by Chenchen LiModerator Thursday, June 8, 2017 2:17 AM
    • Unproposed as answer by jophant Sunday, June 11, 2017 4:04 PM
    Wednesday, June 7, 2017 4:18 AM
  • Hello,

    >>What macro command(s) could I use to force the visible sheet display to always have exactly 10 empty rows at the bottom?

    Excel object model does not provide any method or property to get objects (cell/range/row) in the visible sheet. We could only get all usedrange. but there is no method to identify the cells in the visible sheet. 

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, June 13, 2017 7:55 AM
    Moderator
  • Hi jophant,

    In my memory, your question was about Excel rows.
    Do NOT modify the contents and title of the previous thread.  You should make a new thread for different question.

    Ashidacchi

    Tuesday, June 13, 2017 9:10 AM