Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default Wrong Number of Arguments or Invalid Property Assignment???

Just replace your entire .Clear statement with mine. And check out Resize
in Help.

--
Jim
"tbassngal" wrote in message
oups.com...
| So would it be like:
|
| Cells(i,
| 19).resize(20).resize(21).resize(22).resize(23).re size(24).Clear
|
| ???
|
| This doesn't make sense to me... I've never used this before.
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Compile Error: Wrong arguments or Invalid property Brent E Excel Discussion (Misc queries) 3 May 1st 07 07:11 PM
Compile Error - Wrong number of arguements or invalid property ass James T Excel Programming 2 November 18th 05 07:46 AM
Wrong number of arguments - Help Les Stout[_2_] Excel Programming 6 October 11th 05 08:22 PM
Wrong number of Arguments or Invalid property assignment Turin[_2_] Excel Programming 1 July 17th 05 09:52 PM


All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"