DamienPalmer
New Member
- Joined
- Jan 22, 2014
- Messages
- 1
Hi,
I am new to using Macros and data validation and have run into a problem i am hoping someone can help with.
I am trying to create a macro for estimating purposes that will contain a dependent data validation. The dependent validation will work if i use a direct reference in the second validation
=INDIRECT(SUBSTITUTE(I82," ","_"))
This allows my second selection based on the first.
The problem i have is i want this to run within a macro that can be inserted at any location in the sheet and so the I82 would need to be relative based on where i start. If i try
=INDIRECT(SUBSTITUTE(R[-15]C," ","_"))
I get an error as i am trying to run the macro.
How would be the best way to achieve this?
Thanks Damien
I am new to using Macros and data validation and have run into a problem i am hoping someone can help with.
I am trying to create a macro for estimating purposes that will contain a dependent data validation. The dependent validation will work if i use a direct reference in the second validation
=INDIRECT(SUBSTITUTE(I82," ","_"))
This allows my second selection based on the first.
The problem i have is i want this to run within a macro that can be inserted at any location in the sheet and so the I82 would need to be relative based on where i start. If i try
=INDIRECT(SUBSTITUTE(R[-15]C," ","_"))
I get an error as i am trying to run the macro.
How would be the best way to achieve this?
Thanks Damien
