Posted to microsoft.public.excel.programming

Norman Jones Norman Jones is offline

external usenet poster

Posts: 5,302

inalRow = Range("A65536").End(xlUp).Row

Hi Ciba,

See response at your previous post.

---
Regards,
Norman

"ciba1234" wrote in
message ...

I need a macro to find the final row as --

FinalRow = Range("A65536").End(xlUp).Row

Then to place a text value in the final row.

WHat is the code for this ?

--
ciba1234
------------------------------------------------------------------------
ciba1234's Profile:
http://www.excelforum.com/member.php...o&userid=27299
View this thread: http://www.excelforum.com/showthread...hreadid=468027

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
Using "Cells" to write "Range("A:A,H:H").Select"	Trip Ives[_2_]	Excel Programming	3	June 5th 04 03:13 PM
S1.Range("D65536").End(xlUp).Select	Rick[_19_]	Excel Programming	6	January 13th 04 01:24 AM
RANGE("A65536")	jason	Excel Programming	17	September 5th 03 05:57 PM
Question about "End(xlUp)" property	Dave Peterson[_3_]	Excel Programming	1	August 4th 03 04:24 AM
Question about "End(xlUp)" property	Chip Pearson	Excel Programming	0	August 4th 03 02:57 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us