LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting occupied cell over empty ones Teethless mama Excel Discussion (Misc queries) 1 March 28th 07 02:13 AM
selecting next empty cell ASU Excel Discussion (Misc queries) 9 September 18th 06 02:36 PM
Automatically selecting the next empty row Alec H Excel Discussion (Misc queries) 2 March 1st 06 09:21 AM
Selecting the first empty row webba Excel Programming 8 November 4th 05 01:49 PM
Selecting the first empty row KC Cheung[_2_] Excel Programming 0 August 13th 05 01:22 PM


All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"