Posted to microsoft.public.excel.programming

JDB[_2_]

external usenet poster

Posts: 15

Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value

Thanks for your comments.

JDB

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value	JDB[_2_]	Excel Programming	1	December 26th 10 10:07 PM
Destination:=.Cells(.Rows.Count, "A").End(xlUp).Row + 1	J.W. Aldridge	Excel Programming	5	May 6th 09 09:10 PM
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0,	Simon[_2_]	Excel Programming	2	August 11th 08 01:29 PM
inalRow = Range("A65536").End(xlUp).Row	ciba1234[_2_]	Excel Programming	2	September 15th 05 10:28 PM
S1.Range("D65536").End(xlUp).Select	Rick[_19_]	Excel Programming	6	January 13th 04 01:24 AM

All times are GMT +1. The time now is 06:30 AM.

About Us

"It's about Microsoft Excel"