wscount

This seems like it is frustratingly simple, but I've had no luck with getting my ListBox to deselect or even change its current selection. My ListBox is populated with all the tabs in the workbook (there are 36 tabs with very long names), so when they click the tab name in the ListBox it...

I have a working subroutine that creates a set of hyperlinks in a 'table of contents'. Unfortunately the hyperlink that is created is not working, in a few cases. Context Example reduced in size for clarity Workbook with five tabs and the table of contents tab Workbook worksheet names...

Hi team, Code below. I t is meant to run through the work book and format the Tab name with the name in D6. It has been working fine for a couple months but now it refuses to budge from this error on this line. There are on 10 names that appear repeatedly. Sub Tab_name() Dim ws As Worksheet...

hi! Can't seem to find the fault in my code. Returns an Object required -error. I think the problem lies where it finds the sheet with the *support*-part and the sets it as the active worksheet... Sub help() Dim wscount As Integer Dim ws As Worksheet wscount = ThisWorkbook.Worksheets.Count...