.cells4

Dear All, I run the following code script, then I get an error: "Variable not Defined. What could be the issue, is there an explanation to what is the correct variable not set in the script code? [CODE:] Sub ListSheetNamesInNewWorkbook() Dim wb As Workbook: Set wb = ThisWorkbook...

I have a commandbutton in my spreadsheet, that asks users to choose Yes or No. When Yes is clicked, a macro is called Here is my code to do that (I think this code is ok): Private Sub CommandButton1_Click() Dim Answer As VbMsgBoxResult Answer = MsgBox("Existing data will be cleared. Are...

Have searched the forum, online etc but cannot work out why I am getting "Subscript out of Range" error in the below code. The error is in this line With Worksheets("Journal") The rest of the with (which forms part of the rest of the code, but this is where the debugger shows the error) Sub...