select C column in any sheet
right click on any of the sheet tabs
click Select All
in the formula bar insert yr formula
press CTRL+ENTER

HIH


On 16 Paź, 16:08, Horacio wrote:
Hi Jarek,
What I´m locking for is provide a duplicates in each column C of all the
worksheets.
I´m not very well in vba. Is this code ok to do that?
I know that is possible with a data validation with a formula like
"contar-se(C:C)1" Â*but just one sheet at each time.
My question is: can I do this for all the sheets at same time????
Thanks +
Horacio
Jarek Kujawa escreveu:



one way (to define a validation list) might be to use this macro (that
would insert the validation into EACH worksheet in the workbook):

For Each ws In ActiveWorkbook.Worksheets
Â* Â* With [C1].Validation
Â* Â* Â* Â* .Delete
Â* Â* Â* Â* .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
Â* Â* Â* Â* xlBetween, Formula1:="=range"
Â* Â* End With
Next ws
End Sub

to make it work name yr range containing validation list (e.g. in
worksheet 1) as "range"

HIH

On 16 Paź, 01:38, Horacio wrote:
Hi
Is there any way to insert data validation in the same column (c) of 200
spreadsheets at the same time?
The validation is the same for all the sheets.

Thanks
Horacio- Ukryj cytowany tekst -

- Pokaż cytowany tekst -