ws_count

The following code finds all the Fridays within a date range and then will bold that date. Within my workbook I have 6 sheets with the tabs labeled sheet1(Chart), 2015, 2016...2019. My worksheet is layed out with the date is in column A on all the sheets labeled with a year, on sheet2 the date...

Hi I am struggling to declare and fill in a global/public array. Here is my code Public Function myArray() As Variant Dim WS_Count As Integer Dim i As Integer Dim x As Integer Let x = 0 WS_Count = ActiveWorkbook.Worksheets.Count For i = 1 To WS_Count If...

Hello, I'm trying to have my code figure out how many worksheets there are and to loop through each one to calculate and place the sum of column F in the first blank row in column F in each worksheet. My code is only partly working. Please Help! Sub WorksheetLoop() Dim...

In my workbook I have seven sheets. Sheets four through seven contain values of product information for our four production lines. The below code starts on sheet 4 and loops through each row of column B until it finds the value of the combobox located on the userform named Chattem or...

Earlier I was trying to code a program to count the rows and columns of all the individual sheets of my work book, and then save all of the results into an Array. I have it connected to a button, and sometimes it will just give me 0s as a result when I print the array, and others times I will...

Hey Everyone! I'm having trouble writing code to copy data from a table and paste the important columns under the original to compare the data. I needed to put this in a loop to go through all the sheets of the workbook.. Here is my code.. Any help will be appreciated! Sub CopyData()...

In my workbook I have tabs named Hats, Shirts, Pants and Shoes. Within each tabs, there is a list of the various types of clothing. For example, if hat is selected there is a list of various types of hats located in the sheet with the tab labeled hats that will populate another combobox. I found...

Hi, I'd like to apologize in advance if the following question seems rudimentary as I'm very new to VBA. However, i've written a macro that basically just pastes a row as values for every sheet in my workbook. I would like for this to run automatically at 6 specific times throughout the day...

Still new and still learning, I am close, but can't figure out how to get this to work the way I want. Here is what I have: Sub copytemplate3() Dim WS_Count As Integer Dim I As Integer WS_Count = ActiveWorkbook.Worksheets.Count Dim Source As Range Set Source =...

I have a code which I need to run on all the sheets in a Workbook except "All Employee" Sheet. This code calculates the time spent by the employees in a shift and their less time (Time not completed in a shift) for each day of the month which is logged horizontally in the sheet. The problem I...