Forum Discussion
Solved
Excel (on Mac) Macro Highlight to the Top of a Column
Column F in the below table includes a blank cell. In a macro, I want to highlight cells F2 to F10. Since I could have any number of rows of data, I wrote the macro to get me to the last row of dat...
Change it to
Range(Selection, Cells(1, Selection.Column)).Select
there are various ways. maybe something like:
Range(Selection, Cells(1,Selection.Column()).Select