PDA

View Full Version : Solved: Specific cell selection



justdream
02-12-2011, 01:53 AM
Dears,

Do you know how to force Macro to select the last row in Excel sheet
even if the sheet contains multiple blank rows..

I tried this code but I stucked in between balnk rows

Windows("Input.txt").Activate
Range("A1").Select
Selection.End(xlDown).Select

Bob Phillips
02-12-2011, 03:47 AM
Windows("Input.txt").Activate
With Activesheet

.Cells(.Rows.Count, "A").End(xlUp).Select
End With

justdream
02-12-2011, 04:01 AM
Dear Thanks a lot, I just would like to go down one more row
Sorry

Bob Phillips
02-12-2011, 06:10 AM
Windows("Input.txt").Activate
With Activesheet

.Cells(.Rows.Count, "A").End(xlUp).Offset(1, 0).Select
End With

Paul_Hossler
02-12-2011, 06:10 AM
Windows("Input.txt").Activate
With Activesheet

.Cells(.Rows.Count, "A").End(xlUp).Offset(1,0).Select
End With


Paul