# counter

1. ### Formula to calculate certain dates that will populate rows as separate lines

Hi everyone. I am hoping someone can explain a solution for me in layman's terms please! I am not great with complex formulas. In my original sheet I have the following data as an example: This can be interpreted as Test Employee needs to attend 123 Example Street every Tuesday and Thursday...
2. ### Include a counter in a VBA macro

Dear all, I'm using a macro just to suffle a sequence of numbers and then assign that to a button (attached), as follow: Sub Embaralha_seleção() Dim numm() numm = Range("A1:A100") ct = UBound(numm, 2) lt = UBound(numm, 1) ReDim dex(1 To lt * ct) n = 0 For h = 1 To...
3. ### Search through sheet and count how many cells are blank in a specific column

Hello all, I have a spreadsheet that I fill out as customer requests come in - each request typically takes up 3 rows; the first row contains titles for each column (I know this is redundant, but it needs to be very clear for upper management as they sift through), the second row is details...
4. ### A loop counter

Hello. I am working on a workbook that uses random numbers that loops until a certain condition is met; a specific number. I am wanting to be able to count how many times the loop has to cycle until the number is calculated correctly. Essentially a counter of the cycles. Any help is appreciated.
5. ### Offset and goalseek

hi, I am struggling to get an offset to work on a goal seek i am trying to do. Essentially i want to goal seek a value in row1, column1 to zero by changing the value of the cell in row 3, column 1. In the next round of calculations, ie when i apply the offset, I want to goalseek row1, column2 to...
6. ### Function that counts how many numbers are in a range are between a MIN and MAX

I am trying to create a function that will count how many numbers are in a range on an excel sheet, and also between a min and a max number that are also on the excel sheet (Without using any excel formulas, Ex. countif). The range on the excel sheet also includes empty and non numeric texts...
7. ### get all sheet names starting with a specific letter

I have this vba code but it returns ALL of the sheet names. But I want another-one that returns the sheets that start with the letter "D" and list them in column H58 on "switchboard". Sub WORKSHEETLIST() Dim ws As Worksheet Dim Counter As Integer Counter = 0 For Each ws In...
8. ### Delete column change counter

This seems ridiculously easy, but I cannot figure it out after many tries. Scenario: I have approx 35 columns (and rows of course) of data. I want to sequence through each column and delete any columns that meet a certain condition. Here's one of my many attempts that do not work. Example of...
9. ### stop counting in a cell when another has a date entered

i am working an excel file that i need the counter to stop after i enter date in another cell G4 has date entered: 5-apr-19 H4 is the due date formula: =WORKDAY(G4,9) I4 is counter: =TODAY()-H4 J4 is date completed: 9-apr-19 what i need is I4 to stop counting when J4 date is entered
10. ### For loop with irregular step or use arrays if possible

Hi again, I got something I think is a big problem for me but I don't know what you think: I have a loop like For i = 1 To 100 ......... Next The loop is pointing to numbers in column B. However, all the numbers may not be present. For example, 2 or 54 etc, may not be available in the...
11. ### IF w/Not Equal?

I am trying to delete columns if the header of the column is NOT a header containing the word "Transaction Status" and other headers, but when I run this (below) it doesn't delete columns based on these criteria. It deletes every column. Any help on what I'm doing wrong would be greatly...
12. ### Converting a sub into function

Hello All, I want to convert the below Sub Procedure into a function that I can call into Excel sheet. Sub SplitTextIntoMultipleCells() Dim Counter As Long Dim WordArray() As Variant Dim WordList As Dictionary Dim dKey As Variant Set WordList = New Dictionary...
13. ### Automatic counter based on changes to a cell (inventory usage tracking)

I am a librarian interested in tracking book checkouts over time. I only need to track how often an item has been used, not when or by whom it was used. My library is too small to justify the purchase of an ILS (circulation software), so I am looking for a simpler solution using what I already...
14. ### PivotTable.TableRange is returning the wrong value!

I am trying to determine the number of rows of data in a Pivot field. My code looks like this: Sub LookupCommon() 'A sub to populate the CSV file with common data Set WS1 = Sheets("5. Final CSV") Set WS2 = Sheets("4. PivotTable") Set MyPivot = WS2.PivotTables(1) Counter =...
15. ### Creating Varied Pivot Tables based on a Range Name

I have developed a Macro for my work, and it's going brilliantly. Thanks to everybody on here so far who has helped. The next stage is for me to create pivot tables of the data. I have a table called "Final" data which contains the data for the pivot table, however the format of the pivot...
16. ### error 2007

Hi, I have the following code. When I run it - this line of code triggers an error: Set rng_clients_prev = ThisWorkbook.Worksheets("Daily Totals").Range(Cells(4, col_Arr(0)), Cells(finalRow_clients, col_Arr(1))) error message: Run-time error '1004': Application-defined or object-defined error...
17. L

### Counter count down

how i create counter that count down to 9/5/19. I not sure how do that? i want day hours minutes and sec Thanks you Thomas

I am using a sub I got from the internet that randomly highlights cells. what I need is to have the counter reference a cell instead of being set in the code (see below). I want to be able to put a value in cell H1 and that replace the 150 in the formula. This would make it easier as my sheets...
19. ### Excel VBA: Filtered data returns 2nd result when calling each row

My sheet named Database has numerous rows of data. The first 2 columns have titles, and the user can select from these titles in a drop down list and filter the data so it only displays results that contain these titles. In addition to this, I have another subroutine called GetNextResult. The...
20. L

### I have a world time that have a counter

i have question time that counter for code Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim hour As Boolean hour = Not (hour) Do While hour = True DoEvents Range("A3") = TimeValue(Now) Loop End Sub how i get to start when you open the file witout click anywhere in a cell TY Thomas

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back