excelactuary
New Member
- Joined
- Feb 18, 2013
- Messages
- 45
Hello,
I have code which generates table blocks of different sizes. You have for instance blocks in the following ranges:
D19:F45; H19:J31; L19:N36
I am writing a loop which generates blocks underneath the 3 blocks stated above. If I wouldn't know how big the three blocks are and I would want to leave a blank row between the blocks and start to write the next series of in row 47 (because the cell F45 is at the bottom and I want a blank row), how would I do this? I didn't manage it with End(xlDown).
Thank you for your help!
I have code which generates table blocks of different sizes. You have for instance blocks in the following ranges:
D19:F45; H19:J31; L19:N36
I am writing a loop which generates blocks underneath the 3 blocks stated above. If I wouldn't know how big the three blocks are and I would want to leave a blank row between the blocks and start to write the next series of in row 47 (because the cell F45 is at the bottom and I want a blank row), how would I do this? I didn't manage it with End(xlDown).
Thank you for your help!