VBA countif

[nd272]

Hi hope all is well.

I have a dilemma with a vba project I built. I work in finance and have built a logon system with vba and works perfectly provided there is data there for the person.

I can’t post the code here because of the business I work in. Essentially providing there is data in the applications sheet it in turn customizes a set of graphs and also selects filters on two different pivot tables as well.

Essentially my code works for what I want but I need to address the last item for all in one solution. Do I use something like a countif first before code executes to check if the name is there and if it isn’t it doesn’t try open the sheets. In total I have three sheets I would need to do this on.

 

[Micron]

Not much to go on there. Sounds like you need to ascertain whether or not data exists, so maybe

If Len(Application.VLookup(parameters)) & vbNullString > 0 Then ...?

 

[nd272]

Not much to go on there. Sounds like you need to ascertain whether or not data exists, so maybe

If Len(Application.VLookup(parameters)) & vbNullString > 0 Then ...?

Thanks for responding really appreciate it. I will try remove confidential info from the code I have and upload it. Essentially I have coded logon name and password for 30 staff. Before the code executes and logs them in I want to do a check to see if data appears in one or both sheets and show the data accordingly. If no data is found in either then workbook closes (I have the code for this part).