Avatar of esu4236
esu4236
Flag for United States of America

asked on 

Excel 2013 - VB code for a simple process to move down a single row

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
Programming Languages-OtherVB Script

Avatar of undefined
Last Comment
esu4236

8/22/2022 - Mon