Ever want to paste some data into new empty cell after the last cell with data in certain column? Then take a look at this simple macro.
'first, select cell in the first row of that column, like A1, K1, etc
Range("A1").Select
'move to the last cell with data
Selection.End(xlDown).Select
'move to one row below it
ActiveCell.Offset(1, 0).Select
'paste the copied data in there
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Simple isn’t it? Simple code, but will help us a lot each time we wanna move the active cell into one cell below the last cell contained any kind of data, in the same column.
One requirement needed to use this simple excel vba macro, first we need to select the first cell in the same column where we wanna do the selection.
Pingback: Drug Recall
Pingback: dlc10
Pingback: natural health
Pingback: Juegos de futbol gratis
Pingback: snow fence
Pingback: Digital Cameras
Pingback: the car types
Pingback: www.easyloanfast.com
Pingback: beats pro
Pingback: high pr backlinks
Pingback: powered by
Pingback: makeup coupons
Pingback: hospitality design
Pingback: real work from home
Pingback: inside omnivore's dilemma
Pingback: top social media marketing companies
Pingback: link
Pingback: link
Pingback: emotional healing
Pingback: discount faxless payday
Pingback: thumbnail
Pingback: payday loans no credit check
Pingback: analyze fast payday loans
Pingback: Zithromax Drug Risks
Pingback: view site
Pingback: promoting and celebrating Virginia creativity
Pingback: cumming tree removal