How to select a range of cells using macro
Posted by Brad on December 21, 2000 8:42 AM
I am trying to select some cells using a macro. I have data in column 2 and there are varying amounts of blank cells between the data. I want to be able to select a range starting with an entry then going down until the cell before the next entry (entry and all blank cells below it). I am doing this to format the cells. I want to border each entry and the blank cells below it. Basically I want it to look like a pivot table. All data to the right of this column will be bordered the same so I just need to figure out how to do this column.