I only know a little about VB - enough to be dangerous. If I have the following code, how can I change it to move down a single row without it naming a specific range – “A1342” in this example????? I do not want it to put the actual range in there; I just want to move down a single row. Thanks.
Sub Remove_Blanks()
'
' Remove_Blanks Macro
' Delete blank rows
'
'
Range("A1342").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Delete
ActiveSheet.ShowAllData
Range("A2").Select
End Sub