I want to be able to format a row (borders, shades, data validation, etc.) using a macros. However I want it to be able start from the a cell on any row. I.E. If the higlighted cell is A9, it formats row 9, if the highlighted cell is A300, then row 300 gets formated, etc. The macros works fine from where I started but, I don't know how to get it to work from any row. Is there such thing as a Range("Current").Select line of code?
This message was edited by ammdumas on 2002-05-02 12:44
This message was edited by ammdumas on 2002-05-02 12:44