Re: Cell shading in linked cells
- From: "Carim" <carimfam@xxxxxxxxx>
- Date: 31 Aug 2006 06:34:20 -0700
Hi,
For a start and to be adjusted to your specific needs ...
Sub Dependents()
ActiveCell.Copy
ActiveCell.Dependents.Select
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
End Sub
HTH
Cheers
Carim
.
- Prev by Date: Re: How to create a pivot table
- Next by Date: Re: Functiona Language..
- Previous by thread: Calculating number of workdays
- Next by thread: Re: Cell shading in linked cells
- Index(es):
Loading