I have to create borders on a worksheet. The number of rows in my spreadsheet will vary with each use (can be more or less than the last time used). I am not the end user so I was hoping I could use format painter while recording a macro but that didn't seem to work? Is there another way around this?