Excel VBA .Find issue

[chrisnash70]

Hello I have a workbook, that has multiple sheets the sheets are called the following Supervisors 1 , Supervisors 2, Supervisors 3, Supervisors 4, Staff 1, Staff 2, Staff 3, Staff 4 and a sheet called Summary.

My issue is that when I try to look for Total Supervisors or Total Staff, I get a 'Error code 91 , variable not set'

I am still new to vba and people on here have been so supportive and helpful so can I ask again for all your help and advice.

Please Login or Register  to view this content.

[AB33]

I have not tested it, but you are missing to check if the item exists.
This line appears to be wrong.

Sheets(Sheets(x).Name).

Please Login or Register  to view this content.

[chrisnash70]

When you say i am failing to check the item exists, what do yo mean and how would i check it does exist then, when I run the code I get an error on the same line the cell number may change though.

Please Login or Register  to view this content.

[AB33]

There are a number of issues with the code.
Why are looping twice through a collection of worksheets? It looks like you are nesting the looping over another looping.
Since you are using sheet's collections, why do you need to use a name? The loop uses an index number to access the sheets. Sheets(x) means 1 and the next sheets(x) would be 2 and so on, so you can just use -Sheets(x), unless of course you are trying to name the sheets.
If you have an object, then you need to test if the object exists:
If Not snRow Is Nothing Then
Otherwise, VBA will complain, it could not find the object.

Sheets("Summary").Cells(8, rc.Column - 1) = Sheets(Sheets(xc).Name).Cells(snRowC.Row, rc.Column).Value

[chrisnash70]

Hello is still come sup with the same error code.

But when I comment out part of the original code to exclude the staff it will work without an issue but as soon as I include the staff aspect to it it throws the error code up.

Please Login or Register  to view this content.

[6StringJazzer]

[INDENT]Hello I have a workbook,

Your post does not comply with Rule 8 of our Forum Rules: Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you must provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (most other forums have the same rule).

This thread should have no further responses until a link to the cross-post is added.