.range

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

Hi, For the life of me this doesnt work, any ideas? Many thanks Sub Clear_Estimated_Hours() Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to continue ?" ' Define message. Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons. Title = "Delete...

Hi I am using Excel 2007. When searching the web for answers / tips to writing macros when referencing a range (single cell or several) I have seen both .Range("A1").Value = "" and Range("A1").Value = "" used. Can someone explain in simple terms what the difference is and when .Range or Range...

Every month I run a report whereas the table size changes. I need to be able to account for that. I recorded this: <code>Range("B1").FormulaR1C1 = _ "=IF(VLOOKUP(RC1,sorted!R3C1:R35C33,8,FALSE)="""","""",VLOOKUP(RC1,sorted!R3C1:R35C33,8,FALSE))"</code>I need to have it update...

Hey guys, first and foremost. ALL YOU GUYS ARE AMAZING! I've learned so much from this site (more or less VBA newb) and I just have to say, I am thoroughly impressed with how helpful everybody is on here. Really really awesome! Ok, time for my issue! I am improving a quote spreadsheet I made for...