How to Select Sheet in VBA Coding

[ebincharles]

Dear Bros,

i have strucked in the place where i select the sheet to retrieve the data and update.
Below is the code where i select the sheet.

I would like to select the sheet by cell value, and not by combobox value.

Please Login or Register  to view this content.

I get error "Run-time Error '57121'
Application define error or object defined error


Please help me to select the sheet based on cell value.

Thanks.
ebin

[jolivanes]

Please Login or Register  to view this content.

[bulina2k]

Dear Bros,

Please Login or Register  to view this content.

what you are trying to do here is assign a string value (Sheets("Input").Range("AP5").Value) to a worksheet type object (Set historyWks)
If you want to work with the sheet with the name of that range you could use something like

Please Login or Register  to view this content.

[ebincharles]

@ bulina 2k

Thanks for your reply.

I too tried the same code what you advised.

Please Login or Register  to view this content.

Unfortunately i get error,

Run-time error '57121':
Application-defined or object-defined error

Regards

[bulina2k]

Capture.PNG



What is written in Sheets("Input").Range("AP5") ?
Is there the name of the sheet ?