View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
grebo133 grebo133 is offline
external usenet poster
 
Posts: 1
Default LINKING CELL PATTERNS BETWEEN WORKSHEETS

Along with linking a cell value between worksheets within the same workbook
e.g. storing =APRtoSEP!B5 (worksheet APRtoSEP) in the cell APRtoMAY!B5
(worksheet APRtoMAY), I would like to link the PATTERN (.PatternColorIndex
???? property) for the cell APRtoSEP!B5 in the cell APRtoMAY!B5. Please
advise on the full formula I should store in the cell APRtoMAY!B5 to link
both value and pattern. Thanks.