Hi
I want to ensure a particular part of the macro does not run on the first sheet in the workbook.
Trying to use:
The sheets will have different names each time therefore I've tried unsuccessfully to use Sheets(1)
If ActiveSheet <> Sheets(1) Then
I'm getting the following error:
Object doesn't support this property or method.
Any help would be appreciated.
Thanks
You just missing the Name property
If ActiveSheet.Name <> Sheets(1).Name Then
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks mate worked like a charm
Try this.Or you could loop through the sheets like this, which will skip the first sheet.If ActiveSheet.Name <> Sheets(1).Name Then
For I = 2 To Sheets.Count Set ws = Sheets(I) Next I
If posting code please use code tags, see here.
Try -
If ActiveSheet.Name <> Sheets(1).Name Then 'Whatever You Want End If
Cheers!
Deep Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks