EXCEL VBA Questions and Answers

How can you increase the number of rows in a worksheet?

No one can’t. They’re fixed as 65536(2^16) in Excel 2003 or before and 1048576(2^20) in Excel 2007 & Excel 2010.