View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cbh35711 cbh35711 is offline
external usenet poster
 
Posts: 1
Default Selecting first empty row in column


Using macros...
I'm converting one file to another by copying and pasting data. I wan
to paste the second set, and every subsequent set, below the data
pasted before. The problem is I’m not sure how to select the firs
empty row in column A. I know I could write a loop, but there's got t
be a better way. I've thought of filtering it to show only nothing an
that would allow me to see the first empty row...but I’m not sure wha
command to use after that.

Thanks for any help you can offer,

Chri

--
cbh3571
-----------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...fo&userid=3027
View this thread: http://www.excelforum.com/showthread.php?threadid=52759