How to Automatically Add 10 Rows After the Last Used Row? [SOLVED]

[auriez]

Hello, need to add this into my master VBA code. Would really appreciate any help. Thanks!

 

[Debraj]

Hi Auriez!


Welcome to the forum.. We are glad that you are here..


Now regarding your question..


"Add 10 Rows" is not possible in Excel.. Excel has a fixed number of ROW..


but wait.. lemme clear.. you want to if your lastUsedRow is 234, you want lastUsedRow veriable to set 244..


I think you have code for lastUsedRow, may be xlEndDown or Find("*"..) or A65536.endXlUp or any other method..


Just add 10 with the same Veriable..


For further query.. use Resize or Offset.. try to Google..


Hope it helps..


Regards,

Deb

 

[auriez]

Thanks Debraj !