Hello all,
What I'm trying to do is create a macro that will automatically create boarders for A3:E8. However, the number of rows will vary so I'm gonna have to create a script that will find the last row and include it in the range. However! Row E, has blanks in it, so I can't use it to find the last row.
I'm not very familiar with writing VBA, but I'm gonna play around with it. I just wanted to post it on here and see who can figure it out first :P
What I THINK I have to do is something like this:
1. I would have to create a function to find the last Row of letter M and store the LETTER value in a var.
2. Select A3 and then pull the VAR from above... something like Range(A3:Var)
I don't know if this makes sense. I don't know VBA syntax, otherwise I would have given it a try. I'm gonna study up on it tonight, but I was hoping to get this going today. any help would be appreciated.
Bookmarks