About Us

Michael[_10_]

Thanks Guys !, that works great ! (all of them !)

-----Original Message-----

Hello all,

Is is possible to maniputlate the Worksheet_Change_Method
to alter the struture of a range of cells ?. I have a
range of cells containing data say range(A1:G15).

I have a variable cell (A20) that is adjustable by the
user by entering a value from 1-15.

Now if the user enters a value of say 8 IN (A20), I would
like to delete rows(A9-A15)in the range (A1:G15), and if
it is 4, then rows (A5-A15)etc.

I hope that makes some sense or is it even possible ?

I have looked through the archives for deleting and
inserting cells, but cannot find what I am looking for.

Any help would be appreciated,

Thanks,

Michael

.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please post this thread a correct full method, method about	Nast Runsome	New Users to Excel	8	February 25th 08 03:29 PM
Best method for a monthly archive of a worksheet..	tim m	Excel Discussion (Misc queries)	0	July 26th 06 04:19 PM
Drag down method for getting data from another worksheet at every Nth cell	Bowbender	Excel Worksheet Functions	5	September 22nd 05 03:55 AM
Best method of cloning the contents of a worksheet.	Marie1uk	Excel Worksheet Functions	2	July 6th 05 05:20 PM
Worksheet Change Method	Don Guillett[_4_]	Excel Programming	0	July 24th 03 06:44 PM

Menu

About Us