I have two excel VBA questions... one general and one more specific 1. Let's say I have a Range A1:C6 named "Stuff" Do I refer to specific parts of the range using the offset command? (just wondering what the standard is) 2. Imagine the range is still A1:C6 but I have data in rows 1 and 2. Let's say I want to find the last used row in the range.. I'm guessing the command would be as follows. Would this show 2(last used row) or 6(last row in range) Range("stuff").End(xlup).Row ... if the above shows 2, how do I find the last row in the defined range? Thanks!