2016-05-06 16:16:27 8 Comments

I have a table that ranges from "A:EV".

I want to find the last row of only range "A:DD".

The columns might have blank cells, so I need to go through all and find the furthest row of columns A to DD.

How can I code it?

### Related Questions

#### Sponsored Content

#### 11 Answered Questions

### [SOLVED] Find last row in range

**2016-11-17 09:00:30****atame****57243**View**5**Score**11**Answer- Tags: excel vba excel-2010

#### 3 Answered Questions

#### 1 Answered Questions

#### 4 Answered Questions

### [SOLVED] Loop through each row of a range in Excel

**2009-09-22 23:53:35****Margaret****405092**View**116**Score**4**Answer- Tags: excel vba loops excel-2003

#### 13 Answered Questions

#### 4 Answered Questions

### [SOLVED] Find the last not empty row in a range of cells holding a formula

**2015-11-28 12:18:38****Pascale****4775**View**9**Score**4**Answer- Tags: vba excel excel-2013

## 3 comments

## @Regit 2018-12-19 17:38:31

And with a little voodoo, if you are interested in also getting the column where the last row was found but don't want to extract it from .Address, use this.

## @Regit 2018-12-19 17:21:21

And to adjust the range a bit, change the two column letters in these two lines.

This one searches over columns A:DD.

This version narrows the search range to Y:DD

## @Regit 2018-12-19 17:27:39

And with a little voodo, if you are interested in also getting the column where the lastrow was found but don't want to exract it from .Address, use this.

## @Scott Craner 2016-05-06 17:35:42

Modified from HERE

## @Forward Ed 2016-05-06 18:08:33

Else lastrow= 1000? shouldn't that be 1 for an empty worksheet? Assuming that is the only time you would fall into the else statment

## @Scott Craner 2016-05-06 18:12:47

@ForwardEd yes but I wanted to show that it was not defaulting to the else. I will change it and put a note.