worksheet object

Hi all Using Excel 365. In my VBA Code, I added a worksheet and gave it a name. I reviewed the workbook, I see that the worksheet was added and named as expected I then tried creating a worksheet object based on the new worksheet, but the worksheet object is not being created The code to add...

I want to preform certain code on designated worksheets in my workbook. I only want to do this code for some of the worksheets, but not all of them. What I would like to do is the following: For Each ws in ActiveWorkBook.Worksheets 'do some code Next ws Since I only want to run the code...

I am trying to: Take the input data from a range, all at once (and loading it up in Arrays and Dictionaries) do my business logic export only what I need (worksheet objects), ALL at once (saving going back and forth between the logic and the 'view' - in this case the worksheet) In this case I...