Hi Guys,
Having trouble to find the correct syntax to do a if and statement. Criteria should be: if sheetname = this and activecell is blank
Thanks for your help if you have the answer.![]()
If(and(ActiveSheet.Name = "User Profile", active.cell = "")) Then dothis else dothisinstead End if
Regards, James.
Bookmarks