Finding blank cell in column

[rlnye]

I need to insert a block of text in a spreadsheet two rows below the last entry in a colum...the entries in the column will vary, so the column may have more information sometimes less others.

Hope this explains it okay...thanks alot.

 

[Jim North]

NextRow = Range("A65536").End(xlUp).Offset(2, 0)

 

[rlnye]

May I ask what function "NextRow =" serves in the code?

NextRow = Range("A65536").End(xlUp).Offset(2, 0)

 

[Jim North]

Sure, NextRow is a variable to hold the next row number.... you don't necessarily need it... just depends on your coding style.