Formatting Row with Macros

[ammdumas]

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

 

[waderw]

Try:

sub Format ()
With Selection.row
.font.bold = true
.numberformat = "@"
'whatever code you want
'try recording it if youre not sure
end with