Programmatically changing the Worksheet that is currently visible

[Spotty]

Trying to change the currently activateworksheet within a workbook. I have modified code on the appropriate worksheet and can see this but cannot change the currently activateworksheet to ensure that this tab is the displayed one.

Am I missing something ?

Dim SourceTab = ComboBox3.Text

If String.IsNullOrWhiteSpace(SourceTab) Then

Exit Sub

End If

'Some code to change the content on the Spreadsheet2.Workbook.Worksheets(SourceTab)

Spreadsheet2.ActiveSheet = Spreadsheet2.Workbook.Worksheets(SourceTab)

Spreadsheet2.Workbook.Worksheets(SourceTab).Activate()

[Spotty]

figured it out and used 

Spreadsheet.SetActiveSheet("Name")

[Arulraj A]

Hi Spotty, 

Thanks for the update. 

We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you. 

Regards, 

Arulraj A