Posted to microsoft.public.excel.programming

Norman Jones Norman Jones is offline

external usenet poster

Posts: 5,302

resizing a range

Hi Don,

Set rect.resize(numRows + 1, numColumns + 1)

Should read:

Set rect.resize(numRows + 1, numColumns + 1)

---
Regards,
Norman

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
resizing a range of cells	ckane	Excel Discussion (Misc queries)	4	May 3rd 07 06:08 PM
Resizing a range of cells in a column	ckane	Excel Discussion (Misc queries)	0	May 3rd 07 02:38 PM
Resizing my range - End row	Jacqui	Excel Programming	3	November 1st 05 06:00 PM
resizing a range	Tim Kredlo	Excel Programming	1	September 27th 05 08:30 PM
Resizing a Range	NetWave128[_3_]	Excel Programming	3	April 24th 04 11:16 AM

All times are GMT +1. The time now is 10:03 PM.

About Us

"It's about Microsoft Excel"