Posted to microsoft.public.excel.programming

W[_2_]

external usenet poster

Posts: 2

goto last cell with data

Hi all,

I export a query from Access on which I have to perform statistical analysis.
The data always start at cell A2, but can stop at whatever cell in the A
range. E.g. it could be A345 or A21.

How can I, programmatically, position myself on A2 and then select from A2
till the last "filled" cell, e.g. A345 ?

Thank you,

W

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
Goto last cell	Martin B	Excel Programming	1	February 15th 08 09:52 PM
Goto Data validation Same ERROR	Kate	Excel Discussion (Misc queries)	10	March 17th 05 03:31 AM
Validation Data & Goto question	ma	Excel Discussion (Misc queries)	2	March 1st 05 08:54 PM
Goto end of data & select all rows below	Tempy	Excel Programming	5	June 1st 04 04:36 PM
goto a particular cell	Newbie	Excel Programming	5	April 15th 04 01:46 PM

All times are GMT +1. The time now is 05:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us