Posted to microsoft.public.excel.programming

Johny Looser Johny Looser is offline

external usenet poster

Posts: 1

Range().resize giving errors

Tom Ogilvy wrote:
What you really meant to say was

set rng2 = rng1.resize(, 1 + rng1.columns.count)

Thank!

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
Function giving a result for number within a range	[email protected]	Excel Worksheet Functions	3	February 28th 06 10:57 AM
Range().resize giving errors	Harry Tuttle	Excel Programming	0	December 27th 05 07:04 PM
Macro giving errors at workbook open	kcdonaldson	Excel Discussion (Misc queries)	1	December 6th 05 04:15 PM
How do I add up a range of times giving answer in hrs & mins >24h.	Richard T	Excel Worksheet Functions	2	April 13th 05 04:10 PM
Range.Delete and Range.Resize.Name performance issues	Test.File	Excel Programming	0	February 15th 05 03:33 PM

All times are GMT +1. The time now is 09:54 AM.

About Us

"It's about Microsoft Excel"