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
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