maybe simple question. special cells (unlocked cells)

[Andrew XJ]

Could you tell me how to use Range(aRange).SpecialCells Method to select the unlocked cells in range aRange.
Thx

 

[Juan Pablo González]

First, the sheet must be unprotected.
Then, record a macro to get the correct syntax. Replace the recorded range with aRange

 

[Andrew XJ]

Sorry, i didn't get you. (
But how can i record Macro to select special cells whose locked property is false ? The Macro will only return the exact cells "B1, C2, "... But not SpecialCells...

 

[Ivan F Moala]

On 2002-03-21 20:11, Andrew XJ wrote:
Sorry, i didn't get you. (
But how can i record Macro to select special cells whose locked property is false ? The Macro will only return the exact cells "B1, C2, "... But not SpecialCells...

Do what Juan suggested....however the locked
property of a cell is not avail via specialcells....so you will have to loop
through the range object and test for locked

eg

Dim Rg As Range
Dim oCell As Range

Set Rg = Range("A1:B11")
For Each oCell In Rg
If oCell.Locked = False Then
MsgBox oCell.Address 'do your thing
End If
Next


Ivan

 

[Andrew XJ]

(, so i have no choice but to use slow for loop again. Thank you two anyway!.

 

[Andrew XJ]

(, so i have no choice but to use slow for loop again. Thank you two anyway!.

regards
Andrew XJ