petegrant89
New Member
- Joined
- Jun 28, 2011
- Messages
- 21
I have data in Columns A-BI in groups of rows ranging in number (each group will have a different amount of rows every time the report is run). The groups of data are separated by a row of blank cells. I have been trying to design a macro where I can place my cursor underneath the group of data in column BI, and when I run the macro a designated output cell is populated with the cell reference (coordinates) of the top non-blank cell in column BI before the blank row.
Note: the problem I have been having is that I need this macro to function with all groups of data going down the page, which vary in terms of how many rows they consist of. I need this macro to populate the output cell with the cell reference of the top non-blank cell before the blank row in the group of data that my ActiveCell is currently under, so I can run the same macro for each group of data on the page.
Any suggestions?
Note: the problem I have been having is that I need this macro to function with all groups of data going down the page, which vary in terms of how many rows they consist of. I need this macro to populate the output cell with the cell reference of the top non-blank cell before the blank row in the group of data that my ActiveCell is currently under, so I can run the same macro for each group of data on the page.
Any suggestions?