| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
relative address in validate
HI.
with this code I put the formula in B1 with absolute reference to cell A1: Range("B1").Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=A1" ... ... End With .. Is possible by vba insert a relative address? If I use formular1c1:="RC[-1]" the code doesn't word. Any help will be appreciated. Best rgds M. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| relative address or reference | Excel Worksheet Functions | |||
| How to validate email address during data entry in Excel | Excel Discussion (Misc queries) | |||
| Validate Email address entry | Excel Discussion (Misc queries) | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| what is difference between absolute address and relative address? | Excel Discussion (Misc queries) | |||
Threaded Mode
