1. T

    Resetting Row Counter Loop?

    I have this code here that copies, and pastes from one sheet to another if the match is not found. However, I cant seem to get the row counter to reset to the top of the row. Once it is done looping through a row, it should reset to the second row (as the first row will be a header row)...
  2. S

    Macro For...Next Loop - use counter in FormulaR1C1

    I am trying load Picking Sheets with data from another sheet. I cannot workout the syntax to access the data. Receiving Compile error - Syntax. how do I access the other sheet? Sub Macro4() ' ' Macro4 Macro ' ' Dim OrderCount As Integer For OrderCount = 0 To 600 ActiveCell.Offset(0...
  3. S

    Not counting up

    Hi I'm working on a code to make a copy of my template for every day of the year. All goes well, apart from my counter not counting up to number the folders which are created for every month. This is my code: Function Create_Multiple_Workbooks() Application.ScreenUpdating = False...
  4. M

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

    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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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 =...
  18. 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...
  19. 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...
  20. 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
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
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