Henry San Diego

Posts: n/a

How do I refer to a non-empty row range in Excel

How do I refer a row range, say C1:Cx where x is the last non-empty row in
the C column, but x may change from time to time.
Thanks.
Please reply to .

Henry

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
Excel Range Names	trainer2000	Excel Discussion (Misc queries)	1	May 20th 05 08:42 PM
how to change range for dynamic chart in excel 2000 with button?	ivan	Charts and Charting in Excel	2	April 24th 05 04:10 AM
Eliminate empty cells in data range	Stephen	Excel Discussion (Misc queries)	1	April 2nd 05 04:00 AM
Specify a null value in an Excel Database criteria range	Johnnyy2k	Excel Worksheet Functions	2	December 28th 04 04:43 PM
Excel should let me refer to the same formula on multiple sheets	In need of help	Excel Worksheet Functions	1	December 16th 04 08:21 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us