Posted to microsoft.public.excel.programming

Harold Good Harold Good is offline

external usenet poster

Posts: 81

returning a row number

Hi,

I have a named range "Amount_Local" in a single column.

The following line of code will find the last cell before a blank cell,
which is what I want.
Range("Amount_Local").End(xlDown).Select

How can I get it to tell me what row it is?

thanks,
Harold

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Returning a column name or number	Frank[_4_]	Excel Worksheet Functions	5	July 1st 07 05:58 AM
Searching and returning row number of a value	MikeDH	Excel Worksheet Functions	1	August 9th 05 06:06 PM
Returning a value for a number in a range	Derek	Excel Discussion (Misc queries)	1	July 26th 05 04:47 PM
Returning The Column Number ?	MAS	Excel Programming	2	July 21st 04 09:06 PM
returning max UsedRange row number	drabbacs	Excel Programming	4	February 16th 04 07:59 PM

All times are GMT +1. The time now is 04:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us