Thread: Excel2000: How to copy data validation using VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
  
Posts: 510
Default Excel2000: How to copy data validation using VBA
Solved (found a hint from web)!


Sheets("SheetName").Range("A1:D1").Offset(RowNo - 1, 0).PasteSpecial _
Paste:=xlDataValidation, Operation:=xlNone, SkipBlanks:=False,
Transpose:=False


Sheets("SheetName").Range("A1:D1").Offset(RowNo - 1, 0).PasteSpecial _
Paste:=6, Operation:=xlNone, SkipBlanks:=False, Transpose:=False



--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


Reply With QuoteReply With Quote