llastrow

Hi all Could any of you please let me know if this is possible. The macro below adds the formula 5 times after the last data entry. Is there a way to shorten it, so the rows 1-5 could be on 1 line. Sub Test() Dim lLastRow AsLong With Sheets(1) lLastRow = .Range("K" &...

The following code for deleting blank rows within a range has stopped working for me. I need help with direction for how to make it start working again. Here is the message dialog box that popped up when I did a "Step In" to see if I could figure out what was wrong with the code: Run-time...

Hi, I'm struggling with a formula in VBA. I need a formula for a dynamic range. This is the formula I have in my spreadsheet =SUM(P10:Q16)/(SUM(C10:C16)-SUM(D10:16)) I need help with the code below, which I need to put in the macro. I want it to calculate the cells from row 5 to the last row...

Hi, I found the following code to remove duplicates from each column without taking the contents of other columns into account. However, this code is designed to complete this action for each worksheet in a workbook. For the purposes of my learning more about VBA (I have just started to do some...

Hi Friends, i am new to VBA, need to help with the code i am already using it , Need to add formula In Priced Accessions if Cell P2 = 0 then K2*50% I am using Iferror and Vlook up in the below code, now i also need to ammend where the result came o it will be multiplied by Corresponding...

I am trying to lookup the value in column I, in worksheet "QA Hold", and paste the value from the lookup table in worksheet “Master Part Numbers” A2:B1000, column B, and paste in column J in worksheet “QA Hold”. If I were doing a formula, it would look like this: =VLOOKUP(I2,'Master Part...

I'm trying to run a macro to concatenate two columns J&D to column K. Ive looked through past threads and got this far, but some of my cells are blank in column J&D but would still like to combine the data. What do I need to change to make this happen I'm guessing its something to do with...