last row

I have a range of formulas (E12:O21) The Header Row is (E11-O11) - Total Row is (E21:O21). I want to use VBA to search that range of formulas and find the cells with values to return the "actual" used range within that range. I will use this new range to create a chart eliminating blank chart...

Hello All, I'm making myself a task list, in this list i will have repeating tasks. Once the task is done (and dated) it needs to be done again (think how the laundry is in an never ending loop of despair). I'm VERY new to VBA and despite a few days of google searching (which I, previous to...

Hi all, I need your help for a VBA code that does the next: Find first blank cell in column A (I have this) : Range("A" & Rows.Count).End(xlUp).Offset(1).Select Once you found the last column from A, I need to populate this formula till last row based on column G : =G4. So I will have...

Please can someone tell me how I can amend this formula so that it returns all numbers in column F up to the last row, i.e. so that I can use it repeatedly on workbooks which have different rows of data. Sheets("Lists").Select Range("A2").Select ActiveCell.Formula2R1C1 = _...

Hello. I have this code already that I found on this site and edited it a little bit to my fit my needs. I have two different workbooks. They each have most of the same headers but the order of them can be changed at random times unfortunately. So I need to copy and paste all the data from my...

Hello, I am trying to write a Sub in which I need the number of rows in a Range which is input as a parameter of the Sub. I can't find the syntax to get the number of rows in the range. For other functions where the range is already known (in this case Range("A:A")) when writing, I've been...

hello everyone, Fairly new to VBA. I'm only using simple macros. Just wanting some help with a VBA. I want to copy and paste items from the same cell which I change, into the next line after. Here's what I use so far. But I don't know how to loop it so it does the next line down. I hope that...

I am attempting to retrieve the value found in the last cell/row in column E of a dynamic range. The first row containing data will always be E12 and the last row fluctuates on a daily basis. The formula I am using invariably returns the value found in E12 only - so I am obviously doing...

Hi folks I have an Excel Table with names and abbreviations of names (two columns only). I would like to prevent users from deleting the header row and last row in the table. <tbody> Abbreviation Surname and Initial PM Masters, P JL Leonard, J JM Matsau, J TOTAL 3 [given by...

I have a workbook that launches a userform that gets updated. I need to take all the values in the userform and input that into a different excel file (workbook). It cannot overwrite the data, but enter all new submissions in the last empty row. Any help would be greatly appreciated.

Hello All, I have a piece of code that I need to modify since it works so well, it essentially is a Last Row Lookup (Column Based) and defines the last row with an actual formula result. What I need: I have a variable to replace the column letter "ColumnL" that I need to update the line of...

Hi, any help on this is greatly appreciated! I'm trying to find the last row with data and highlight it yellow. I started with finding the last row but don't know the rest :) Help! Sub HighlightLastRow() Dim LastRow As Long With Sheets("Sheet1") LastRow = .Cells(.Rows.Count...

Hi Folks, I am trying to get data from multiple workbooks into 1workbook, building up a large data source. The code should open each workbook selected, copy cellsA3:AP and last row and then paste into the new workbook at the last blank row. I am currently struggling with finding the last row to...

Thanks in advance for the help. The calculation sheet has several API keys that determine distances between multiple start points compared to one end point. The data dump sheet list all my end points that I want to know the optimum distance. Instead of manually going line by line, I would like...

I'm trying to set print area based on how many rows in a range are not blank. I have tried the offset function to dynamically set a range, but Excel keeps converting the dynamic range to a static range. I'd like to have a button to press that says "print" and will set the proper print area in...

Hi Gurus, Looking for your help to fix my code below, what I am trying to do is to update my table vertically, instead of horizontally. Just to clarify, I was updating my data like this: <tbody> A B C D E F G 1 2018-30 2018-31 2018-32 2018-33 2018-34 2018-35 2 Open 27 26 25 27 28 30 3...

Hi Everyone, In a formatting step of a larger macro, I am trying to select a variable number of rows beginning with cell C9:J, and then sort alphabetically. Below is what I have written, but it doesn't seem to be working so far (no errors given though). Dim LRowC As Long LRowC =...

I have this Formula in my VBA: "=IF(COUNTIF(ProblemAnalysis!R2C[" & Count & "]:R[" & lastRowProb & "]C[" & Count & "],RC[" & Count & "]=0,""No"",""Yes"")" And have set these: Count = (Range(rngAddress1, rngAddress50).Columns.Count - 1) * -1 lastRowProb =...

I am not sure how to do this on VBA, I want to sum a range that will start on P7, and also where will it show me the answer? Sub suma() Dim rng As Range Dim answer As Long LastRows = Sheets("Draft").Range("P" & Rows.Count).End(xlUp).Row Set rng = AD.Worksheets("Draft").Range("P7" &...

Hi, I have this Macro where it select a range and paste it on a specific cell, is there a way it can do it on the following of the last row. Sub CopiaDetalle() Dim rng As Range Ultimafila = Range("C" & Rows.Count).End(xlUp).Row With Sheets("U-Detail") Set rng = Range("C11:AC" &...