Microsoft Excel - Preserve Varying Row Heights When You Copy And Paste In Your Macros (Excel 2000/2002/v. X/2003)
It may be common place to copy and paste a data range as part of a personalized macro. However, you may not realize that the way you format the range reference can impact how Excel copies that data. For example, if you enter a data range as 1:83 instead of A1:N83, you're actually instructing Excel to copy and paste a range of rows, as opposed to a range of cells. As a result, rows of varying height maintain those different heights when Excel pastes them in a new location. If you copied and pasted the data range as A1:N83, Excel wouldn't include row height in the attributes of the data range. This can really come in handy if you're using smaller empty rows to improve the worksheet's spacing!