Linked Questions

Possible Duplicate: How can I find last row that contains data in the excel sheet with a macro? Error Finding Last Used cell In VBA If I have a spreadsheet and the largest row number which has ...

I have a code, which basically makes one formula for B10, then it copies it all the way down and insert it back as values to remove the formula and make it more 'clean'. My issue is that I have a ...

I am currently attempting to find the range at which data occurs within column 3, Dim dataWs As Worksheet Set dataWs = ThisWorkbook.Worksheets("Cleanwaste") lastRow = dataWs.Cells(dataWs....

When I want to find the last used cell value, I use: Dim LastRow As Long LastRow = Range("E4:E48").End(xlDown).Row Debug.Print LastRow I'm getting the wrong output when I put a single ...

column A has data like this (ie frequent blank cells): HEADING <-- this is A1 kfdsl fdjgnm fdkj gdfkj 4353 fdjk <-- this is A9 I would like to be able to get the cell reference of the last ...

How can I determine the last row in an Excel sheet, including some blank lines in the middle? With this function: Function ultimaFilaBlanco(col As String) As Long Dim lastRow As Long ...

I've found this method for finding the last data containing row in a sheet: ws.Range("A65536").End(xlUp).row Is there a similar method for finding the last data containing column in a sheet?

I have an excel sheet in which I need to find the last non empty cell in a specific row. How do I do this? The below will select this for me, but it will select the first not empty cell, I need the ...

I wrote a short VBA code to automate stuff. A short snippet is as follows: Sub TEST() Rows("1:2").Select Selection.Delete Shift:=xlUp Range("A1").Select ActiveSheet.ListObjects.Add(...

I have looked at the suggested questions to find the answer to my problem. The closest question is called: Count number of rows in a different Excel Sheet Count number of rows in a different Excel ...

I'd to select all rows from 2 adjacent columns, starting with the row below the header (this is fixed) and ending with the row before the first row with a blank cell. Given the following the example.....

I'm presently using the below code to copy paste the range, but it creates a really large file once the data is pasted, how can I modify this to copy paste only till the last active row? Or is the ...

I'm trying to write a macro to create graphs in excel 2007. I don't know the number of cells that will be in the range for one of the series of data (it could be anywhere from 50 - 1000). I've ...

I've been trying out various ways of finding the last row in a range and returning this number to a subroutine, to no avail. Here's the code I have Sub StartHere() Dim oSheet As Worksheet ...

I am trying to create VBA code that copies and pastes data from Column B into the row directly beneath in Column A. I do not have great experience with VBA and so I am struggling to create such a ...