Posted to microsoft.public.excel.programming

CAPTGNVR[_2_] CAPTGNVR[_2_] is offline

external usenet poster

Posts: 87

HOW TO FIND last cell from activecell?

DEAR ALL

Excel97: in COL A, have say 50 rows 1 to 50. Again have row 70 to 150
another seiral numbers 1 to 80.

Suppose if cell A25 is clicked, how to use countA to find the last cell in
row 1 to 50.

Pls bear in mind that xlup etc cant be used bcos from row 70, i have another
serial numbers.

Pls sugest what VB. Thnks

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
How To Find If The ActiveCell Is Protected	FARAZ QURESHI	Excel Discussion (Misc queries)	7	April 13th 09 05:03 PM
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Excel Discussion (Misc queries)	1	October 2nd 07 08:05 PM
if activecell = the cell below	×¨×•×–× ×˜	Excel Programming	2	December 28th 05 05:30 AM
Find ActiveCell.column	LindaMac	Excel Programming	4	November 10th 04 05:48 PM
Use of Selection.Find & ActiveCell	Steve Slechta[_2_]	Excel Programming	4	November 19th 03 02:07 PM

All times are GMT +1. The time now is 10:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us