Formatting Row with Macros

ammdumas · May 2nd, 2002, 01:43 PM

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 · May 2nd, 2002, 01:47 PM

Try:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 01:43 PM	#1
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	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 ]

May 2nd, 2002, 01:47 PM	#2
waderw Board Regular Join Date: Apr 2002 Posts: 85	Try: sub Format () With Selection.row .font.bold = true .numberformat = "@" 'whatever code you want 'try recording it if youre not sure end with