Please need help with last row with data
Posted by Veronica on January 04, 2002 1:07 PM
How can I get programmaticaly the address of the last row (not rows or cell) that have info from column D.
Actually what I need is a macro that will select the printing area in a worksheet and set it up as printing area; that will be starting from the right down corner, D34 to A1; the problem is that the number of rows changes so if I use reference to the cell D34 it will not work when I have more or less rows. So I need to make referece to the address of the last row with info in column D. Thank you so much for your help.