View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Yngve Yngve is offline
external usenet poster
 
Posts: 67
Default cells interior/color index

Hi tandavina

The best way for you to learn something like this (the same as for
everyone
- myself included) is to use the Macro recorder on the Tools...Macros
menu

This is always the best way to start when you don't know what objects
you
need...

When you have finished recording the actions that you need the code
for,
click Stop on the Tools..Macros menu, and use ALT-F8 to show the Macros
dialog.

Select the new macro that you just recorded, and choose 'Edit'

then you can see the code that has been recorded, and this will help
you see
what objects are used, and give you a head start.

If you are still stuck modifying the code, let uis know and we'll help
....

Regards Yngve