counter

  1. RCONDADO

    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...
  2. lockarde

    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...
  3. J

    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.
  4. R

    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...
  5. D

    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...
  6. K

    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...
  7. bobkap

    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...
  8. C

    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
  9. kelly mort

    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...
  10. bobkap

    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...
  11. SharmaAntriksh

    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...
  12. L

    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...
  13. T

    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 =...
  14. T

    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...
  15. 3

    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...
  16. 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
  17. T

    Hopefully easy answer

    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...
  18. R

    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...
  19. 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
  20. R

    Including a counter within an advanced filter

    I have an advanced filter set up and separate to that subroutine I have another subroutine that loops through the filter results and places the value into a text box. That all works fine but I'm trying to include a counter so for every result that's being displayed the counter goes up, and then...

Some videos you may like

This Week's Hot Topics

Top