View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PaulD PaulD is offline
external usenet poster
 
Posts: 92
Default Select a Range and Format

"Jaina WIlliams" wrote in message
...
: I am looking to do 2 things
: 1 I want to select the whole worksheet and remove any
: fill colors and then
: I want to select a specific Range in a spreadsheet (eg
: B5:d10) and right Justify all the data in the worksheet
:
: Thanks

Have you tried using the macro recorder while doing this? It will write the
code for you.
Paul D