Formula for selecting the second row down (Not necessarily row "2"
 

I have the following command:

lastrow=Cells(Rows.count, "A").End(xlup).Row

I need the formula to select the second row down

Formula for selecting the second row down (Not necessarily row "2"
 

The second row down from what?

Rick


"Megadrone" wrote in message
...
I have the following command:

lastrow=Cells(Rows.count, "A").End(xlup).Row

I need the formula to select the second row down

Formula for selecting the second row down (Not necessarily row "2"
 

hi
add an offset....
lastrow = Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Row

regards
FSt1

"Megadrone" wrote:

I have the following command:

lastrow=Cells(Rows.count, "A").End(xlup).Row

I need the formula to select the second row down

Formula for selecting the second row down (Not necessarily row
 

I'm sorry,

The second row down from the top of the spreadsheet (row 1)

"Rick Rothstein (MVP - VB)" wrote:

The second row down from what?

Rick


"Megadrone" wrote in message
...
I have the following command:

lastrow=Cells(Rows.count, "A").End(xlup).Row

I need the formula to select the second row down

Formula for selecting the second row down (Not necessarily row
 

Here is the info.

Market = Application.InputBox("Enter your market Example: test")

lastrow = Cells(Rows.Count, "A").End(xlUp).Row
Firstrow = Cells(Rows.Count, "A").Top(xlDown).Row
Selection.AutoFilter Field:=5, Criteria1:="Market"
Range(("D1" & Firstrow), ("D1" & lastrow)).Select
Range(("D1" & Firstrow), ("D1" & lastrow)).Activate
Charts.Add
ActiveChart.ChartType = xlAreaStacked
ActiveChart.SetSourceData Source:=Sheets("3rd Quarter Daily
(07)").Range(( _
"D1" & Firstrow), ("D1" & lastrow)), PlotBy:=xlColumns
ActiveChart.Location Whe=xlLocationAsObject, Name:= _
"3rd Quarter Daily (07)"

"Rick Rothstein (MVP - VB)" wrote:

The second row down from what?

Rick


"Megadrone" wrote in message
...
I have the following command:

lastrow=Cells(Rows.count, "A").End(xlup).Row

I need the formula to select the second row down