View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Christian[_8_] Christian[_8_] is offline
external usenet poster
 
Posts: 17
Default Pasting rows below the last row with data?

Hi flurry

try the following

LCopyToRow = Application.CountIf(Worksheets("Diary").Range("A:A "),
"<")



'Select row in January or February to copy
Rows(LSearchRow).Copy Destination:=Worksheets("Diary").Rows(LCopyToRow
+ 1)


'Move counter to next row
LCopyToRow = LCopyToRow + 1

Cheers Christian