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!

Go back