Posted to microsoft.public.excel.programming

Ant[_3_]

external usenet poster

Posts: 3

Recording a macro

I am trying to select the top 10 rows of a filtered list and then paste the
values into a temporary worksheet. I have tried several ways of recording a
macro that will do this but without success.
Currently the line of code that is selecting the range reads
"Range("A1:E11").Select". What should this read to always be the top ten
rows of a filtered list?

Thanks
Tony

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
recording a macro	Heela	Excel Worksheet Functions	2	September 19th 07 08:40 PM
Recording a macro	Sharon	New Users to Excel	1	March 21st 07 08:23 PM
My excel macro recorder no longer shows up when recording macro	jack	Excel Discussion (Misc queries)	1	February 5th 07 09:31 PM
My excel macro recorder no longer shows up when recording macro	jack	Excel Discussion (Misc queries)	3	February 5th 07 08:22 PM
Macro recording	grahamp	Excel Programming	2	March 31st 05 01:13 PM

All times are GMT +1. The time now is 12:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us