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
m_tarler, Range(Selection, Cells(1,Selection.Column()).Select turns red when I paste it into the macro.
Change it to
Range(Selection, Cells(1, Selection.Column)).Select