i.value

Hello, The following code applies a filter in a sheet and it does it right. Then, I apply a FOR and an IF to do some operations. The problem is that the for doesn't take into account the filter and it goes though the whole column instead. Do you know how can I fix this? Thanks!! ultima_fila =...

Hello, I was wondering if it is possible to detect a merged cell or range on one sheet(Sheet1) and merge the same cells in another sheet(Sheet2)? The columns being copied over go from B to H in a loop I am copying them row by row until LastRow. Not every cell in each B H range...

Hi, So I have the following code Private Sub CloseForm_Click()Unload Me End Sub Private Sub ListBox1_Click() 'Load Textboxes For i = 1 To 8 Controls("TextBox" & i).Value = ListBox1.List(, i - 1) Next End Sub Private Sub UpdateRow_Click() 'Load sheet with textbox values Dim i As...

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

Hey I have a table in access called Log_Table Id like the user to press a button that checks if the value "KLAR" is in the column named "HRWEBB CHECK" How do i do this? Ive done it with Excel, but dont know how to make this code work in access (code from excel, how to make this work in...

I am trying to modify my macro 1) to have order not matter in the columns 2) show what is missing from either column 3) sort the results in lowest to highest example column 1 column 2 5 3 1 1 7 5 2 7 Sub Compare() ' ' Compare Macro '...

Hi all. I got a question regarding a file that I'm working on since yesterday. I got this table: I need the data to be like this: So If a person has 3 OK's The code needs to return the column header and create a duplicate for every column header. I got this code now. Sub BlankLine()Dim Col...

Hi! I am trying to add the numbers in column C (starting at C3 to C2000) with the numbers in column E and have the results go back to C. Ex: C3=C3+E3 Then C3=0 I have found this code online that I have adapted, but it doesn’t seem to work. Nothing happens except that it tells me that I have a...

Hi Guys, im trying to copy rows from one sheet to another based on their rating, Rating is in column E (Long,medium or short) and i have 3 sheets with each name. I have a list with movies and based on their rating i want the entire row to be copied on the specific sheet. here is my code. Sub...

Hi, I am using a macro to pull data from a PDF sadly for some reason when I pull the lines of data random "." appear in the data. I have a test to run through each line and format the special characters out but sadly It condenses everything down, so now instead of removing all characters I...

Currently having a worksheet "invoice" with cell range of A19:F41 that will be able to input data and will be copying from worksheet "invoice" to worksheet "report" using the below code. But in between the range A19:F41, may have chances where some rows have no data in between some rows with...

I feel like this code is taking way too long to process (2-3 minutes). It's quite basic so was wondering if there were any ways I could improve it? Sub Sample1() Dim LastRow As Long, i As Long Dim ws As Worksheet Set ws = Sheets("Sheet1") LastRow = ws.Range("A" & Rows.Count).End(xlUp).row...

Hello All,<o:p></o:p> I have Sheet1 , Sheet2 and Sheet3 in a workbook. <o:p></o:p> Can anyone edit the code vba code below to make it work justonly SHEET1 and not other sheets. <o:p></o:p> Thank you. PubliccurSheet<o:p></o:p> PrivateSub btnsearch1_Click()<o:p></o:p> Dimi, LastRow, caseFound...

Hi, I have two sheets with a list of data on each, both have ID codes for each row, but they don't always match: Sheet 1 should have all the codes but it also duplicates some, and the duplicates must be retained: Eg 1 2 2 2 3 3 4 5 6 7 7 8 9 [...] Sheet 2 doesn't have all the codes: 1 2 3 5 7...

Hi all, I am trying to write a code to search a strings listed in the active sheet in all excel files in a folder having multi level of subfolders. I searched and found following code which is working for me but I need to search only sheet called "Test" in each excel file. This code searches in...

Hello, I currently have a script dumping information into an email however the date format in my spreadsheet is too long and i'd like to cut it down to just display the Hour currently the date is formatted like this: 01/08/2017 8:00:00 AM and I would prefer to just show 8 (8am basically) and...

Wracking my brain on this one. I have a class module which is populating various attributes of a list and is storing them in a collection. The collection is being built just fine, but I'm unable to figure out why the heck the collection key isn't working, despite me explicitly defining it...