Last cell with constant in a sheet

Posted to microsoft.public.excel.programming

Raj[_2_]

external usenet poster

Posts: 150

Last cell with constant in a sheet

Hi,

I am looking for code for finding the last cell with a constant in it
(the cell in the lowest row and the rightmost column of the range
displayed in Edit--Go to--Special--Constants.)

Thanks in advance for the help.

Regards,
Raj

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
The cell currently being evaluated contains a constant	Frustrated	Excel Discussion (Misc queries)	1	March 15th 10 04:42 AM
text in a cell invoke constant date in another cell - how	Frode Inge Helland	Excel Discussion (Misc queries)	1	September 18th 08 09:25 PM
Is there a way to set a cell value to be constant in formulas?	Marshall	Excel Worksheet Functions	4	November 2nd 07 04:29 PM
Constant cell	Aurora	Excel Worksheet Functions	1	February 14th 06 03:08 PM
Pasting constant formula where referral sheet changes	Nicole M.	Excel Worksheet Functions	10	January 1st 06 07:54 PM

All times are GMT +1. The time now is 05:55 AM.

Menu

About Us