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

You forgot to include xlWorkbook.save() 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--

Website
My Blog
Reply With Quote