Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
Hi,
I received excel file every date to work on.. more than 100 row and it depends ..... how do create data validation macro for only for 100 row or 200 rows. Actually I have used macro recorder to put validation & it validates to whole column. I dont want to put validation for whole column , i need only upto the value available in corresponding column. Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
Here is code from a recorded macro
With Selection.Validation .Delete .Add Type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop, _ Operator:=xlBetween, Formula1:="0", Formula2:="50" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = True .ShowError = True End With Just change selectioion to the range your want With Range("a5:D20").Validation .Delete .Add Type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop, _ Operator:=xlBetween, Formula1:="0", Formula2:="50" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = True .ShowError = True End With "muddan madhu" wrote: Hi, I received excel file every date to work on.. more than 100 row and it depends ..... how do create data validation macro for only for 100 row or 200 rows. Actually I have used macro recorder to put validation & it validates to whole column. I dont want to put validation for whole column , i need only upto the value available in corresponding column. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |