lyass
May 4th, 2002, 11:33 AM
i have an Excel workbook where sheets are named "1","2","3" etc. i want to run a macro that would activate or select the specific sheet based on the number in the clipboard from the other non-microsoft application. for example: if the clipboard contains "23" the macro should open worksheet "23". I believe this number should be pasted somewhere but i didn't find a place to paste it