Posted to microsoft.public.excel.programming

Matt S

external usenet poster

Posts: 112

relative reference for LastRow

All,

I am trying to find out the last row of the column that I am currently
residing. I believe the following code only looks at column A. How can I
modify it for the column I have selected?

LastRow = Cells(Rows.Count, "A").End(xlUp).Row

Thanks!!!!
Matt

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 an offset formula for the reference in a relative reference	Cuda	Excel Worksheet Functions	6	November 15th 06 05:12 PM
Relative Reference	liseladele	Excel Programming	2	April 28th 06 08:29 PM
Relative reference	Lakebum	Excel Worksheet Functions	2	December 28th 04 05:57 PM
Relative Reference	Barry Givens via OfficeKB.com	Excel Discussion (Misc queries)	3	December 17th 04 07:31 PM
Go to lastrow using other column's lastrow	stakar[_14_]	Excel Programming	5	April 16th 04 03:42 PM

All times are GMT +1. The time now is 04:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us