lastr

HI All, Could someone please help me comment out the below macro on what each or a line does. This is used to auto assign task but I am trying to tweak few things but dont know where exactly i need to change things up. If someone can help me comment the line for example 'This splits colums or...

I have a userform (TagForm) with a listbox that has the Rowsource controlled by the code below basically the code finds the range for the Rowsource, by first finding the Column (Colon) then the Last Row (Lastr) of data in that column, the top row of the Range is always 5, then the range.name...

Hi, I have a table that has dynamic range and I need to set a loop macro to generate PPTX, I have all the macros but I'm struggling with how to write the loop macro: These are the macros: This macro generate all employees under this manager: Call reset_List_Leader_Organization Dim rSht As...

Hi, I need help to convert following code with any loop. Can I get any help, please. thank you Dim lastR As Long lastR = Cells(Rows.count, "N").End(xlUp).Row - 5 Range("O6").Resize(lastR) = "=IF(N6<>"""",N6)" Range("P6").Resize(lastR) = "=IF(N6<>"""",N6)" Range("Q6").Resize(lastR) =...

Hey all, I must be missing something really simple, I am trying to enter a formula to populate department names for their counterpart number and I keep encountering errors, the debug is highlighting the formula but I can't figure out what I am doing wrong: Sub AutoFillFormula()...

Hello – I am trying to run this loop where I autofill Column M from M5 all the way down to the last row (last row is based on Column E). It performs just fine for the sheet I run it on but then it just stops. No error message or anything but it fails to continue the process throughout the...

Hi, I have a list of names in column D, each name is repeated 8 times. I have formula in columns F:CM. Columns F is the only one that has a merged cells (F3:F11 are merged, and repeated down column F) , so that instead of showing the name 8 time it only shows once. I'm trying to create a macro...

Hi guys - working on a project to set some formulas to the lastrow. normally I would use the "Cells(Rows.Count, 1).End(xlUp).Row" type method because it works great for me. But for this worksheet I am unable to use this method so I spotted a column that defines the last row based on a cells text...

Hi. I have a piece of code that helps me select multiple CSV files and then import them into one sheet where I will then run additional scripts to build output data. I'm looking to automate the process more and trying to circumvent the selection of the CSV through the manual process and rather...

Hello, I wrote a change event macro based on the user entering a number higher than 1 in the range D4:D27. It’s working, currently. I want to add a condition so the macro only runs if the corresponding cell in column B has the word “Survey” or “Review”. I tried using an And statement on this...

I am using the code below and it works, but it only runs about 30 lines and it crashes. The error is" Run-time error/automation error. Does anyone know why its crashing and how I could prevent it from crashing? If it gets an error can it just skip to the next line? The stock tickers go in column...

Hi, I've got a list with data based on streetnames in column 2 of ws Data (=straat in dutch) and dates in ws.(cells Lastr, 1). I wanted to sum up the weights that are in Column 3 of Sheets(Data) for each month individualy. Now I used this macro, but I have to change to smaller then and greater...