I have a macro that will create a report. It will overwrite old data and generate a new report each time the macro is run. Since the data length is not consistent, I'm trying to use relative references but struggling with adding a border on the last row of data (the formating gets wiped when I erase the old data).
Basically, I need cells B3:K[LastRow] to have a bottom border. Unfortunately, with the code below, if there is an empty cell in the first row of data, the XLToRight function stops at the open cell and doesn't go all the way to Column K. Column B will always have data in it, so XLDown works no problem.
Please Login or Register to view this content.
Bookmarks