Posted to microsoft.public.excel.programming

NDBC

external usenet poster

Posts: 204

deleting a range

Could you please tel me why this wouldn't work

Sheets("a lap").Range(Cells(Target.Row, MaxCol + 4), Cells(Target.Row, _
256)).ClearContents

I'm running it from some code in a sheet called A grade if that makes a
difference.
Maxcol is dim as integer.

Thanks

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
Deleting range	Orlando	Excel Programming	1	September 7th 07 04:04 AM
Deleting a range	Don Guillett	Excel Programming	1	January 9th 07 05:42 PM
Deleting Range name's listed in the range address box.	Satnam Patel	Excel Discussion (Misc queries)	4	May 5th 05 01:42 PM
Deleting Range using VB	sjbeeny	Excel Programming	5	May 29th 04 12:14 PM
Deleting range not a row	Robert[_13_]	Excel Programming	3	September 1st 03 11:12 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us