counter

Good day guys! I'm new to VBA and use Google to find my syntax, so I may be missing something basic here, but as the title suggests, I'm trying to list all the number formats in my workbook as well as count how many cells actually use them. My code gives results, but the results are wrong...

Hello all, I have a multisheet-workbook. In a for loop including if statement and an increment, I visit all the sheets starting from the third one, the code works for the first sheet but for the second sheet, the counter is not incremented. Could you please help me to solve this problem...

I have a workbook that has a csv string and dumps all my information on one page in 3 columns and i have a series of loops that searches through all the data and copies and pastes the information on another sheet. After that i have another loop that goes through the data copied and deletes the...

Hi all I am looking for any help I can get on the below I'm trying to write code behind a user form that operates when you selected a contract number via a dropdown list, it then populates the textboxes, comboxes and listboxes where appropriate on the user form. Some of the fields might...

Hello all, Long story short, I have a piece of code here that is supposed to compare two experts in a head to head style on who has more clients. Whoever has the higher number, the code should highlight the cell with the higher total. If they are tied, it then compares a second category, pace...

Hi All, i am getting a error sub or function not defined in vba, can any one help. Sub xyz() counter = 1 Sheets("Sheet3").Select For k = 6 To 200000 DOBval = Cells(k, 1) If Mid(DOBval, Find("", DOBval + 1, 6)) = "App.No" Then DOB = Cells(k + 1, 1) counter = counter + 1...

I have these formulae in cells: =IF(ISERROR(A1/B1),0,A1/B1) =IF(ISERROR(C1/D1),0,C1/D1) How can I create this in a VBA array? For Example: Dim DataArray() As Variant DataArray = Cells(1,1).CurrentRegion.Value Dim MyArray(1 To 10, 1 To 2) As Variant Dim Counter As Integer On Error...

Which of the two methods below are preferable? Method1 with error handling: Sub Start() On Error GoTo Errhandler For Counter = 1 To 1000 i = 1 Do Until TableArray(i, 1) = MyArray(j, 1) i = i + 1...

I have some data on my worksheet a follows: a 1 a 2 b 3 b 4 I want something to sum the values according to the value in column a, ie I want a to return 3 and b to return 7. Dim MyArray() As Variant MyArray = Cells(1, 1).CurrentRegion.Value Dim Counter As...

I am running a current macro. when it gets to a specific line, it keeps opening an personal macro that is tied to the sheet. none of my code is calling for it. this is driving me crazy and I don't know why it is doing it. current macro line that is causing the personal macro to pull up...

Hi All, I have created a exam/test in excel but am stuck in with the below issue, i want that a single user can only have three attempts to clear/pass the test, failing which the user can not take the test unless we do not reset the counter again. It will be a great help if some one can guide...

The following code does not run across all of my worksheets. It seems to just run the same code on the first tab multiple times. Can someone help me fix this? My best guess is that that the ActiveCell member is causing this issue, but I do not know how to fix this. Sub...

How can I create a macro to remove from the dataset duplicated data? If there are two versions, one of them is removed entirely, leaving just a single version in the dataset. I have to inform the user how many data have been removed in total. FYI, I have over 50,000 data. Can someone help me to...

Hi Friends, can you pls help me out with the code which can hyperlink the active cell value mentioned in the sheet,and open that folder and its file whichever i will choose to open from it. My code is doing upto 70% of the task, but unable to open the choosing file from it. It throws the error...

Hi, I have written a process that will populate a template sheet with string data data (names) from a source sheet. It works fine. However, there can be more than one name in a target cell. So I'd like the process to append any strings to the cell if it is not empty, separated with a comma and...

hi there I am just trying to adjust this code so that when it pastes the new info it starts on the 3rd row. Currently it starts on the 2nd row and erases information I need.... I have pretty much tried adjusting everything but cant do it. Sub Fargos() Dim wsScores As Worksheet Dim...

Hi, I have difficulty in conceptualizing how to do this in excel and require some help. My goal is to be able to have a dynamic contract row in the "Cash Flow" tab. That means if I choose 5 from contract term in the "Inputs" tab, it will show 0, 1 (in F3), 2 (G3), 3 (H3), 4 (I3), 5 (J3) in the...

I get a daily report, and since the columns included in this report change sometimes, I created a test for new columns. This code is SUPPOSED to move any new columns over to the right, and color each new column red. It only does the first half. It successfully moves the new columns, but I can't...

I have a range in a worksheet (eventually similar ranges in many worksheets). The range is 8 rows long and runs from columns B to I. The range is sorted in ascending order based on match criteria that return rows in column I for data in column E. I am trying to delete rows where the row matches...

Hello, I am trying to find a way to identify updates in a column using a Conditional Formula. I have 3 columns, WO ID, WO Flag and Package Counter. The counter is counting the number of common WO IDs. Next, I would like to create a conditional formula to highlight (in red) when text in the...