variable assignment

I need to create a unique ID for tracking stuff and I've used the following to do it for now, but it's not ideal as I need to scale this ability to others as well. Current solution: 1) Open spreadsheet, insert a new column and find First Name(E2) and Last Name(D2) fields and adjust the following...

Hello, I am trying to use named ranges in a VBA function but I am getting a "Compile error: Sub or Function not defined". What I am trying to do is a countifs function: a = Range("K1") b = Range("A:A") - lookup range for a c = Range("L1") d = Range("B:B") - lookup range for c e = Range...

Apparently this happens when a variable is not defined, but all mine are, as far as I can tell. Also, when debugging, the error appears on the End Sub line. That is, the macro (seems to) exit correctly, but as it exits I get the error msg. If the error box could be forced to not appear it would...

Sub GatherInfoHimchanLooping() Dim exclude As String Dim endrow As String: endrow = Sheets("Info").Range("E100").End(xlUp).Row Dim Finalrow As String: Finalrow = Sheets("Info").Range("I100").End(xlUp).Row For i = 24 To endrow exclude = Cells(i, 5).Value Sheets("Data").Select...

Hi all, I'm working on a loop that will look-up and place values (text or numbers) into a collection of combo and text boxes in a Userform. I have 75 comboboxes and 150 textboxes in the userform (2 textboxes under each combobox). Lets say the name of the comboboxes are as follows: Cbox_1...

Hi all, The logic on this one is stumping me. Hoping someone can help me out, as I'm not quite following what the issue is here: I'm building a pivot table from data using VBA. When adding a row field, if I am adding it based on a variable it fails, but if I add it explicit it is fine...