View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ToddS ToddS is offline
external usenet poster
 
Posts: 9
Default Macro for Selecting Cells within a Range

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!