View Single Post
Old 10-09-2014, 08:47 PM
Rapiant's Avatar
Rapiant Rapiant is offline
Join Date: Jun 2008
Location: Iowa
Posts: 111

You forgot to include in your code. if you don't want to override values you need to have your code look at the values in your cells in then find the first empty cell.

Dim EmptyRow As Long
EmptyRow = Cells.SpecialCells(xlCellTypeLastCell).Offset(1, 0).Row
--Adam Lee--

My Blog
Reply With Quote