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: 3
Default Determine First non blank cell in col without Macro

Is there any way to use a worksheet function to determine the first non
blank row in a column? In a macro, I'd use something like this:

The_Row = Range("A1").End(xlDown).Row

Is there any worksheet function that can do this without a macro?
 
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
Determine last blank cell in row? [email protected] Excel Worksheet Functions 8 May 21st 07 10:03 PM
How to determine within a macro if a cell contains a hyperlink. Richard L. Miga Excel Discussion (Misc queries) 4 May 8th 07 12:32 PM
How do you determine if a field is blank in a logical expression. Van Excel Discussion (Misc queries) 2 December 5th 05 10:08 PM
Macro skipping blank cell bossbubba Excel Programming 1 February 5th 04 07:50 PM
I need to determine a cell range based on a blank cell Katrina Excel Programming 1 July 3rd 03 09:11 PM


All times are GMT +1. The time now is 11:38 PM.

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"