vba - Check cell value in a table excel? -


trying check if cell value in "calendar" contained in table ams, wich located in sheet in same workbook error item specified name not founf...help please

sub look()   activeworkbook.sheets("calendar").select  range("c7").select  if intersect(activecell, [ams]) nothing       msgbox "activecell not in table1"    else       msgbox "yup"    end if 


Comments

Popular posts from this blog

Ansible warning on jinja2 braces on when -

Parsing a protocol message from Go by Java -

html - How to custom Bootstrap grid height? -