How can I use vba to find the name of the first sheet in a workbook?
I use this code to copy from the first sheet to another sheet in the workbook:
What I want is to use some vba code to return name of the first sheet in the workbook to a vaiable that I can use in the code. Something like this:
strFirstSheet = "somehow find name of first sheet"
Maybe a strange problem but it makes sense in my setting. Appreciate any help.