I am a novice macro writer and need help with the following. Here is a piece
of a macro I recorded:

Range("P:P,N:N,L:L,J:J,G:G").Select
Selection.NumberFormat = "#,##0.0_);(#,##0.0)"

The end result I am shooting for is to change the number format as described
above but only for certain cells within the columns I have named in the first
line. Can I modify that line to include the names of these cells or is it
more complicated than this? Help!

Todd,

For example, to only change rows 3 to 10 within your range:

Intersect(Range("3:10"), Range("P:P,N:N,L:L,J:J,G:G")).NumberFormat = "#,##0.0_);(#,##0.0)"

--
HTH,
Bernie
MS Excel MVP


"ToddS" wrote in message
...
I am a novice macro writer and need help with the following. Here is a piece
of a macro I recorded:

Range("P:P,N:N,L:L,J:J,G:G").Select
Selection.NumberFormat = "#,##0.0_);(#,##0.0)"

The end result I am shooting for is to change the number format as described
above but only for certain cells within the columns I have named in the first
line. Can I modify that line to include the names of these cells or is it
more complicated than this? Help!

I guess I should've clarified. I have a list of bases in column B. there
are certain bases that must be included (effectively EXCLUDING the remainder)
in this range of other columns to which I am applying the formatting (the
columns in the line below - P, N, L, J and G) and I wasn't sure how to refer
to them in the macro.

"Bernie Deitrick" wrote:

Todd,

For example, to only change rows 3 to 10 within your range:

Intersect(Range("3:10"), Range("P:P,N:N,L:L,J:J,G:G")).NumberFormat = "#,##0.0_);(#,##0.0)"

--
HTH,
Bernie
MS Excel MVP


"ToddS" wrote in message
...
I am a novice macro writer and need help with the following. Here is a piece
of a macro I recorded:

Range("P:P,N:N,L:L,J:J,G:G").Select
Selection.NumberFormat = "#,##0.0_);(#,##0.0)"

The end result I am shooting for is to change the number format as described
above but only for certain cells within the columns I have named in the first
line. Can I modify that line to include the names of these cells or is it
more complicated than this? Help!