var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Get an instance of a sheet from codename string?
I have a lookup that returns a string Code name of a wks say sheet3
is there a way I can get a worksheet object referencing sheet3 from a string?
Dim wks as worksheet
wks = activeworkbook.sheetsFromCodeName("Sheet3") ?
I think you're saying that you will have a variable that (using a lookup) contains the sheet name as a string, so you want something like:
Dim wks as Worksheet
wks = ActiveWorkbook.Sheets(VariableHoldingSheetName)