Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Amending code question
If TargetColumn holds the value '7' and myRange is dimmed as
Range, how may I 'Set' myRange to get all populated cells in Col 7, so that I can then do: On Error Resume Next myRange.SpecialCells(xlCellTypeConstants, xlNumbers) _ .ClearContents myRange.SpecialCells(xlCellTypeFormulas).ClearCont ents On Error GoTo 0 Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 25/11/2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Amending a formula | Excel Discussion (Misc queries) | |||
Amending another formula | Excel Discussion (Misc queries) | |||
Amending date formats. | Excel Discussion (Misc queries) | |||
Help amending code | Excel Discussion (Misc queries) | |||
Help with Amending this Code Please | Excel Worksheet Functions |