Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2

Selecting rows with variable

Im trying to select, then delete a whole lod of rows in
one go. Im trying to use the following commands:
Rows("4:" & count_y ).Select
Selection.Delete Shift:=xlUp

It doesn't like this at all. How can I get it to do what
I want?

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
Find a single value from tables by selecting two variable inputs?	jj023	Excel Worksheet Functions	8	February 17th 10 01:40 AM
Selecting a variable print area in a macro	Surrealest	Excel Discussion (Misc queries)	2	June 7th 09 07:08 AM
macro syntax for selecting variable range	Matt	Excel Discussion (Misc queries)	1	October 31st 07 07:13 PM
Selecting Variable Data Ranges	rc	Excel Discussion (Misc queries)	2	May 18th 07 08:26 PM
after selecting 50 rows of a column i can't reference the cells in the rows	Bob Salzer	New Users to Excel	2	July 21st 06 10:29 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us