ws.name

I have the following VBA code which works except part bolded. Basically I want the "control" sheet to summarise the data from the other sheets - the item specified in cell B7, the name of the sheet, the values from N7:Q7. The cells N7:Q7 are formula but I want the values calculated to be pasted...

I am getting a run-time error '1004' Method 'Visible' of object'_Worksheet' failed when running a macro. I have to have the workbook protected to keep users from deleting sheets. The code works great when the workbook is unprotected. I had to change it workbook_deactivate instead of...

I am a novice VBA user. I have a menu page with different cells that all hyperlink to hidden sheets. All sheets unhide except a few that give me the "Run Time error 9 - Subscript out of range". Where is my error? Thank you for looking! Below is a pic of the debug (Error is in RED) line and...

I found this code in the forum and am trying to use it to rename a particular tab in by workbook. The problem is it is trying to rename every tab or worksheet I have and I only need it to change the name of 1 sheet. how can I modify the code to only name the one tab? Sub tabname() Dim ws As...

Good afternoon, The below code only adds the worksheet name to column cell range D2-D5 regardless of what text is in cells D2-D5. Can I get your guidance to amend the code that if there is a word "Category" or "Store" in column D that it adds the worksheet Name and _with the cell value which...

The dictionary items are not showing Sub Tracker()Dim a, w(), i As Long, ii As Long, n As Long, z As String, ws As Worksheet, dic As Object Sheets("Tracker").Range("a6: b100000 ").ClearContents Set dic = CreateObject("Scripting.Dictionary") dic.CompareMode = vbTextCompare For Each ws In...