This is a bit beyond my reach. I'm needing to write some vba that I can assign to a macro button which will select the names of those sheets determined by a marker "X" running from a front page summary sheet which is basically as follows:
Tab Name (Col A7:Z Last row) is where the sheet names...
Hi,
I have a macro that will select multiple sheets at one point. I'm trying to think of a way to recall that selection later on, possibly by naming it when it's first selected. I thought something like this would work, but no dice:
SheetstoPrint = Sheets(ActiveWindow.SelectedSheets)
...
Hello, I hope some Darling can assist me.
I have a macro that selects all sheets - no matter how they are named - or how many sheets there are (normally 5 to 10 new sheets).
The problem is that there are sheet names in my macro and I might have one new sheet or two with different names from...
I have put together a Userform for entering data into a series of identical spreadsheets in the same workbook. The form contains a combo box that switches the active worksheet by selecting the sheet's number. However, once the new sheet is selected, the Userform continues to edit the cells in...