Hello! I have created the following code:
Dim lastCol As Variant
Dim lastRow As Variant
Dim cel As Variant
Dim test As Range
Set ItemRange = Application.InputBox("Select range of the Item/Component Column. Starting on row 2 of that column, drag it down to the last cell"...
I was trying to make a VBA code that would compare a list on a page "Locations", and go through all of the other sheets comparing a column in these sheets to see if there is a match or not. If there was no match, ignoring blanks, the VBA code would go to the cells where the match...
I've got the below VBA code which works but after it runs when I look at the tab it has the range use selected still. It's not a huge issue but I'm curious, how do I remove that selection on each tab?
Private Sub CommandButton1_Click()
Application.DisplayAlerts = False
Dim crnt As...
Today I found a bug in my workbooks that only causes a problem sometimes.
I have a source worksheet that has stock index close price data on it. In the past I used a macro to retrieve that data by selecting the range/copy to a different worksheet.
Today I noticed that since I used...
Is there a way to find "used" products from my list of "out" products and "returned" products?
"out" and "returned" products may have the same product code
we ship "out" about 100 products (some have the same product codes) and they "return" 90 products
Can anyone help me with this code that I have problems doing for the last 2 days. What I need to do is find the last column in that particular row starting from column H onwards, if there is any text that shifts down the row in column G and repeat the action; when it finds the text in a cell it...
Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is:
Type a name, (let's think that I have 3 people call Jessica but with different last names), when I click in search, I want to be able to see displayed the 3 names Jessica inside the list box
The sheet name...
The image shows an ActiveX Combo Box
On clickin the drop down the button does not present the linked list, instead it presents another drop down button inside the list area which when clicked presents the list required.
Not all persons in my team have the issue.
Changeing the combo box...
I am pretty new to VBA and I could really do with some help with a spread sheet.
I need to copy data from multiple rows (I only need up to offset 0,10 from these rows) when a cell in the range A1:A30000 in the sheet entitled DATA equals the value of TextBox7, to another sheet...
I have a macro I want to iron out... I need to copy/paste specific columns from one work sheet to another. I believe I have it to where when I run the macro, it will successfully copy/paste the columns.
My problem is the way I wrote the macro, it only knows to do it between two certain...
First off, I'm open to a variety of solutions for this situation. I'm currently working on using excel to make a searchable database of documents. I'm hyperlinking the articles, and have some advanced filter settings right now. I'm making a column that contains keywords that relate to the...
I've got problem. I receive phone number hashed by MD5 (00037b319ddf1495b2e7ae64e29a8ef5). I need to get this number from our mysql database.
So mysql query is: SELECT MD5(c.mob) phone, c.mob phone1 FROM db_hu.hu_cust c WHERE MD5(c.mob) IN ('00f9758dd73300b4025ea916c8a3e024');
I'm a beginner in terms of VBA and so I need help in finding duplicate data in columns then automatically deletes or selects them for deletion.
Here's a macro VBA code I found on the internet but it only displays the word "duplicate" in another column.
My problem here is there is already a VBA code for finding duplicates but the problem here is that.
It still takes too much time to click all the duplicates 1 by 1 just to delete them, for example:
Imagine a column filled with 5000 data and the duplicates found are around 1500, I can't possibly...
I want to rearrange some data in an excel table.
I have a variable ID_Nr defined as double and it is a number between 2 and 100. I want the macro to look for that number in column A and if found select the whole row and delete it.
That way I am trying to eliminate all rows with...
Hello everyone!! Hopefully somebody can help me!
I am using VBA to create an email from Excel that includes in the body of the message a table that I am selecting as an specific range.
The problem that I have is:
I have not been able to select just the dynamic range that contains values.
Hello I hope somebody can shed some light for me.
I have a macro button on my s/sheet that runs pretty well to highlight todays date within a row. However it also red borders the left and right side of the column below and im not sure why? It is quite useful and I would like to have the same...
I created a combo box in the form to select the record and export to excel (I created a button). Please advise how to make the combo box with one blank at the top of the list so that I select the blank, then all record can be exported to excel.
i want to select a value from dropdown list and have tried below code, but can't work.
please take a look:
<select name="fldcusval" nchange="fnSetBankName();fnSetCurrencyList()fnGetCustomer();;displayDetails (this);">..</selec>
I've received and modified a simple VBA from another excel and i was wondering if anyone could help me modify even more. The thing i need is that the range of this code would be across all documents worksheets.
I1,I2,I3 stays in the first sheet. Date and Name in any other if I2 or I3...