$$Excel-Macros$$ Re: Cell Validation using VBA

2011-02-05 Thread Rob
Thanks for your suggestion. Have given up and have now implemented code to perfrom validation myself but really appreciate your response. My first time using the forum and impressed with the support out there , so thank you. On Jan 31, 11:34 pm, clivey wrote: > mmm...this rings a distant bell ! >

$$Excel-Macros$$ Re: Cell Validation using VBA

2011-01-31 Thread clivey
mmm...this rings a distant bell ! Any chance you could use Record Macro to autogenerate some code to analyse for clues? Also keep an eye on datatypes. Clivey,London. On Jan 30, 9:15 pm, Rob wrote: > Can anyone help please? > > I have tried to apply the following VBA code in order to establish a