Posted to microsoft.public.excel.programming

Mikhail

external usenet poster

Posts: 9

how to fill gaps in Current Region?

Dear Excel experts!
Thank you all for your valuable help.
IMHO the most elegant solution is Range("A2").CurrentRegion.Resize(,56).copy
Thank you again.
Mike510

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
Current region emulation	daverau	Excel Worksheet Functions	5	October 16th 09 04:31 AM
Sort doesn't recognize current region	RobWN	Excel Worksheet Functions	2	September 7th 07 10:48 PM
Naming Current Region	Gavin[_4_]	Excel Programming	3	October 14th 03 03:38 PM
Trying to convert a used range into a current region	a	Excel Programming	2	September 25th 03 06:00 AM

All times are GMT +1. The time now is 04:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us