Forum Discussion
sezinozer
Dec 22, 2020Copper Contributor
Limit number of rows an excel file can have
I have a macro file at hand. I save it as workbook after adding values and upload to a company system. This system accepts at most 20000 rows, also I need at most 1000 rows. Right now I can see around 1million rows .
If I delete a row, just a new one appears. I can no way reduce number of rows.
- Please don't offer me to hide rows, since hiding is not getting rid of useless rows they are still there.
- Scroll area resets itself everytime. It is useless as well.
plz let me now if there is a macro code for this
2 Replies
Sort By