View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
whornak whornak is offline
external usenet poster
 
Posts: 5
Default Macro Effecting Formatting

When creating a new workbook, inserting code that will apply
formatting/filtering/sorting/calculations, insert result set into sheet,
launch macro: I experience some weird results.

1) At most but not all calculations don't work even thought the formula
appears correct.
2) All cells, including those involved in the formula, won't show the format
dialog when: Right click, select Format Cells, GET NOTHING.

Excel 2000.